MrExcel Publishing
Your One Stop for Excel Tips & Solutions

XLDOWN?


Posted by Mike K on July 14, 2000 9:30 AM

I need code so that i can get to the end of my data and then paste in more data. How does the xldown work?

thanks


Posted by Ryan on July 14, 0100 12:54 PM

You can use this:

LastRow = Range("A65000").End(xlUp).Row+1

This will bring you to the next empty row. Hope this helps.

Ryan