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?

thanks!


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

Try adding this:

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