Find Next Blank?

[lhernandez]

I am using a macro to search through a worksheet(Sheet1) and output the needed info. onto a new worksheet (Sheet2). I would like to use this macro to search through a different worksheet(Sheet3) and output the needed info. on to the same worksheet that was used before(Sheet2).
Is there a way I can search for the next blank to continue outputting the data on the same sheet?
Any help would be great.
Thank you

 

[Joe Was]

For the column that gets your data, do something like this:


ActiveSheet.Range("A65536").End(xlUp).Offset(1, 0).Value = my next data item