Thread: How to Select A Cell in VBA with a Variable Row Number?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David Godinger[_2_] David Godinger[_2_] is offline
external usenet poster
  
Posts: 15
Default How to Select A Cell in VBA with a Variable Row Number?
Works great! Nice and simple.

Thanks!


On Saturday, March 24, 2012 3:33:30 PM UTC-7, Jim Cone wrote:
Dim lngRow as Long
lngRow = Range("XRow").Value


Range("K" & lngRow).Select
-or-
Cells(11, lngRow).Select
Reply With QuoteReply With Quote