MrExcel Publishing
Your One Stop for Excel Tips & Solutions

find next blank column

Posted by Julie Scheels on January 09, 2002 6:26 AM

I have a set of data (2 - 3 columns) that I want to copy to
a spreadsheet, then I need to recalculate and copy more
data to the same spreadsheet, but in the next blank columns,
how do I do this?


Posted by Scott on January 09, 2002 6:33 AM

Try adding this:

ActiveCell.Offset(0, 1).Range("A1").Select