Change reference style in line of code
Application.goto worksheets("sheet1").range("d1")
Qualify as much as you like (include the workbook, too???).
Biff wrote:
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
--
Dave Peterson
|