Thread: to find cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Pete McCOsh Pete McCOsh is offline
external usenet poster
  
Posts: 64
Default to find cell
Vikram,

Dim LastRow as Integer

LastRow=Range("A65536").End(xlUp).Row

Cheers, Pete.
-----Original Message-----
I want to find cell in column A which is blank after the
used range in
the sheet

like if the used range in sheet 1 ends in A20000, i want
to find cell
A20001

THANKS A LOT


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

.

Reply With QuoteReply With Quote