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?