> I don't know what the range is that you are referring to but:
"... The original code references rows 2 to 259 in Column A. I have
since
named A2:A259 "MyRange" ..."
So the range I'm referring to is A2:A259.
(I named this range in the Excel sheet by selecting the cells and
entering "MyRange" in
I don't know what the range is that you are referring to but:
Sub Macro2()
Range("A1:A3").Select
ActiveWorkbook.Names.Add Name:="MyRange", RefersToR1C1:= _
"=Sheet1!R1C1:R3C1"
Application.Goto Reference:="MyRange"
End Sub
It is the Goto that I think you want
Thanks,
David
On
