That works and is compact at the same time!

Thank, Tom

Biff

"Tom Ogilvy" wrote in message
...
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