How to enter data in row in popoulated column

M

mtsark

From reading this forum I know there should be an easy way to do this but I just can't seem to figure it out.

I am trying to write a macro to fill in some Item Descriptions (a text string) starting in the first available cell (this will be a different cell each time) in a given column (say Column A). This macro would then continue down the column entering the same Item Description until the adjacent column (say Column B) is empty. I think I have the DO...LOOP UNTIL figured out but I can't test it until I find a way to make that last cell active.

Thanks,
Matt
 
T

Tom Ogilvy

cells(rows.count,1).End(xlup)(2).Select

--
Regards,
Tom Ogilvy

mtsark said:
From reading this forum I know there should be an easy way to do this but
Click to expand...
I just can't seem to figure it out.
I am trying to write a macro to fill in some Item Descriptions (a text
Click to expand...
string) starting in the first available cell (this will be a different cell
each time) in a given column (say Column A). This macro would then continue
down the column entering the same Item Description until the adjacent column
(say Column B) is empty. I think I have the DO...LOOP UNTIL figured out but
I can't test it until I find a way to make that last cell active.
 
Top