xlend syntax in VBA-guru help needed

S

Stuart Farr

I'm sending the cursor to row 65,536 in Col D. I then want to get Exce
to send the cursor to the last row of data in Col D effectively b
using "End Up" key strokes. In VBA I have to do this by using "xlend
but am unsure of the syntax. Once there, I need Excel to tell me th
row number so I can use this as my parameter in a DO While loop.

Can anyone help please
 
T

Tom Ogilvy

lastrow = cells(rows.count,4).End(xlup).Row

You don't need to send the cursor anywhere. Just use a reference. It is
faster and more efficient.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top