Thread: Go To Location
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Go To Location

Try

Range(Range("A1").Text).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"choice" wrote in message
...
in cell A1 i have a reference to another cell (example: R27)
i need a code that goes selects the cell that is in A1
im thinkin range("a1.value").select but thats not working

thanks in advance