xlend syntax in VBA-guru help needed

  • Thread starter Thread starter Stuart Farr
  • Start date Start date
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
 
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.
 
Back
Top