Thread: Change reference style in line of code
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Change reference style in line of code
If you want to go to the cell listed in cell D1 then

On Error Resume Next
Application.Goto Reference:=Range(Range("D1").Value)
On Error goto 0

--
Regards,
Tom Ogilvy


"Biff" wrote in message
...
Hi Folks!

Application.Goto Reference:="INDIRECT(R1C4)"

How do I change the R1C1 reference to an A1 reference?

When I use either "D1" or D1 I get errors.

Thanks

Biff




Reply With QuoteReply With Quote