Thread: Find and select LastRow Minus 1
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Carlie[_6_] Carlie[_6_] is offline
external usenet poster
  
Posts: 1
Default Find and select LastRow Minus 1

Thanks guys. I went for the:

myLastCell = Cells(myLastRow - 1, myLastColumn).Address

and works fine

--
Carli
-----------------------------------------------------------------------
Carlie's Profile: http://www.excelforum.com/member.php...fo&userid=3337
View this thread: http://www.excelforum.com/showthread.php?threadid=53350

Reply With QuoteReply With Quote