Go to row # that is in a cell
 

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?

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?

Go to row # that is in a cell
 

application.Goto reference:=range("A" & range(CustomerCount").value)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bill_S" wrote in message
...
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?

Go to row # that is in a cell
 

Try this

Application.Goto Range("A" & Range("CustomerCount").Value)

Or if you want it to be the first row
Application.Goto Range("A" & Range("CustomerCount").Value), True


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bill_S" wrote in message ...
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?