Thread: Go to row # that is in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mars1968@gmail.com is offline
external usenet poster
  
Posts: 2
Default Go to row # that is in a cell
Try
Cells(Range("CustomerCount").Value, 1).Select

Mike

Bill_S wrote:
I need VBA code that will go to the cell in column A and the row # in my
named cell CustomerCount. For example, if the value in the CustomerCount
cell = 77, then I need the code to go to cell $A$77. Can this be done in a
single command?

Reply With QuoteReply With Quote