Thread: Find the last used Row on a Worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
poppy poppy is offline
external usenet poster
  
Posts: 1
Default Find the last used Row on a Worksheet

Hi Experts

Is it possible for me to select the blank row immediately after th
last used row? I am trying to do something like this, but it's no
working:


Code
-------------------
lastrow = Cells(Rows.count, "B").End(xlUp).Row
lastrow2 = lastrow + 2
Range("A65536").End(xlToRight).Select = "lastrow2"

OR

Range("lastrow2").End(xlToRight).Select

-------------------


Kind Regard

--
popp
-----------------------------------------------------------------------
poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145
View this thread: http://www.excelforum.com/showthread.php?threadid=32006

Reply With QuoteReply With Quote