Look for next blank cell in a column

[Lorna]

This should be an easy one for you experts out there.

I have a column of data on a Sheet1 called Products and another column on Sheet2 called OrderedItems. I want to be able to add selected items from the Products column to the end of the list in the OrderedItems column. How do I tell Excel to go to the next available blank cell in that column?

Thanks

 

[Sal Paradise]

In VBA, you can use

Range("A1").End(xlDown).Offset(1,0)

to find the next empty cell in a range as if you hit Ctrl-Down Arrow, followed by down arrow in a spreadsheet.

Is that what you were looking for?

 

[Lorna]

Yes, Sal, that's exactly what I needed. I knew it was something really easy. Thanks!