Writing code to fill a column

[dalewms2]

Can someone tell me how to write the code below to fill the cells with "IORY"?

Also, when I recorded the macro I use commands like shift + end + down arrow. If I have a worksheet that has a different amount of data that exceeds A145 will that macro use the same commands or use the same range? If this is the case how can you write a macro that is flexible?

Please Login or Register  to view this content.

[tigeravatar]

dalewms2,

Something like this?

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[shg]

Let's back up a step: Exactly what are you trying to do?

[dalewms2]

I am new at VBA and without re-writing the entire code I am trying to fill these cells with "IORY". thanks

[dalewms2]

thank you. Can you look at the 2nd part of my question?

[tigeravatar]

range.End(xlDown) mimics using shift + end + down arrow. I'm with shg on this one, what exactly are you asking for?

[dalewms2]

I am asking because this is my first macro with this file extraction. The next time the file may have a greater amount of rows. I just want to know when the macro says: [Range("A2:A145") and the next worksheet has the range A2:A175 , the macro will include the entire range. If not I need to go back and edit the macro. thanks

[ChemistB]

Yes, you will need to rewrite the entire macro. It will always use the range A2:A145. Your entire macro (as shown in your post) can be replaced by the single line that Tiger gave you. I hope that helps.

[dalewms2]

When I use range.End(xlDown) do I need to specify a column? If so, please give me an example.

[ChemistB]

It will use the move down from whatever range is specified. In tiger's example, (Range("A2") it would be column A.