I want to paste data into a sheet that already has data in it. I nee
to identify which cell to paste the new data into. I do not want t
over-write the existing data. I need to:

1) identify the first empty row
2) indentify the first empty column
3) pass these values to two separate variables
4) use these variables in an offset or address method to define th
paste cell for the data (i.e. if row 10 and column 2 are empty then th
cell address to paste to will be B10)

Does anyone know how to do this?

Thank-yo

--
Message posted from http://www.ExcelForum.com