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

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

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.

--
Regards,
Tom Ogilvy


"Stuart Farr " wrote in message
...
I'm sending the cursor to row 65,536 in Col D. I then want to get Excel
to send the cursor to the last row of data in Col D effectively by
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 the
row number so I can use this as my parameter in a DO While loop.

Can anyone help please?


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

Range("D65536").End(xlUp).Select
MsgBox ActiveCell.Row

Regards.

"Stuart Farr " wrote in message
...
I'm sending the cursor to row 65,536 in Col D. I then want to get Excel
to send the cursor to the last row of data in Col D effectively by
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 the
row number so I can use this as my parameter in a DO While loop.

Can anyone help please?


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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.674 / Virus Database: 436 - Release Date: 02/05/2004

Thanks a lot Tom, absolutely perfect

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