Thread: finding ROW without selecting worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim at Eagle Jim at Eagle is offline
external usenet poster
  
Posts: 83
Default finding ROW without selecting worksheet
Sheet4.Select
Sheet4.Range("G59").End(xlUp).Offset(1, 0).Select
Dest1 = ActiveCell.Row

Would like to locate the row # without selecting the worksheet or the range.
Is that possible when different worksheet is active?
--
Jim at Eagle
Reply With QuoteReply With Quote