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