How to enter data in row in popoulated column

[Guest]

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

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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.