Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A1 reference style
Hi folks!
Application.Goto Reference:="INDIRECT(R1C1)" Why won't that accept an A1 reference? Both of these fail: Application.Goto Reference:="INDIRECT(A1)" Application.Goto Reference:="INDIRECT("A1")" Thanks Biff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A1 reference style
Martin,
I tried this: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) I get a run-time error 1004 Let me further explain: A1 contains a defined name like Product1. Product1 refers to cell A100. I have the macro attached to a button. I click the button and are taken to Product1 (cell A100). It works just fine using the R1C1 reference but I'm trying to simplify it for others who may be confused seeing R1C1. P.S.: the line of code I posted was generated by the macro recorder. Application.Goto Reference:="INDIRECT(R1C1)" Thanks Biff "Martin Fishlock" wrote in message ... Biff, Goto requires a range object. There you need to do the following: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Cells(1, 1)) 'or Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) But it may be easier just to do thew following: range(ActiveSheet.Range("A1")).select -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "T. Valko" wrote: Hi folks! Application.Goto Reference:="INDIRECT(R1C1)" Why won't that accept an A1 reference? Both of these fail: Application.Goto Reference:="INDIRECT(A1)" Application.Goto Reference:="INDIRECT("A1")" Thanks Biff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A1 reference style
ooops!
Disregard the last post. It does in fact work just fine. Thanks, Martin! Biff "T. Valko" wrote in message ... Martin, I tried this: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) I get a run-time error 1004 Let me further explain: A1 contains a defined name like Product1. Product1 refers to cell A100. I have the macro attached to a button. I click the button and are taken to Product1 (cell A100). It works just fine using the R1C1 reference but I'm trying to simplify it for others who may be confused seeing R1C1. P.S.: the line of code I posted was generated by the macro recorder. Application.Goto Reference:="INDIRECT(R1C1)" Thanks Biff "Martin Fishlock" wrote in message ... Biff, Goto requires a range object. There you need to do the following: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Cells(1, 1)) 'or Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) But it may be easier just to do thew following: range(ActiveSheet.Range("A1")).select -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "T. Valko" wrote: Hi folks! Application.Goto Reference:="INDIRECT(R1C1)" Why won't that accept an A1 reference? Both of these fail: Application.Goto Reference:="INDIRECT(A1)" Application.Goto Reference:="INDIRECT("A1")" Thanks Biff |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A1 reference style
No need to create "range of range"
Application.Goto Reference:=activesheet.cells(1,1) or Application.Goto Reference:=activesheet.range("a1") should work just fine... -- Regards, Luc. "Festina Lente" "T. Valko" wrote: ooops! Disregard the last post. It does in fact work just fine. Thanks, Martin! Biff "T. Valko" wrote in message ... Martin, I tried this: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) I get a run-time error 1004 Let me further explain: A1 contains a defined name like Product1. Product1 refers to cell A100. I have the macro attached to a button. I click the button and are taken to Product1 (cell A100). It works just fine using the R1C1 reference but I'm trying to simplify it for others who may be confused seeing R1C1. P.S.: the line of code I posted was generated by the macro recorder. Application.Goto Reference:="INDIRECT(R1C1)" Thanks Biff "Martin Fishlock" wrote in message ... Biff, Goto requires a range object. There you need to do the following: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Cells(1, 1)) 'or Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) But it may be easier just to do thew following: range(ActiveSheet.Range("A1")).select -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "T. Valko" wrote: Hi folks! Application.Goto Reference:="INDIRECT(R1C1)" Why won't that accept an A1 reference? Both of these fail: Application.Goto Reference:="INDIRECT(A1)" Application.Goto Reference:="INDIRECT("A1")" Thanks Biff |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
A1 reference style
Application.Goto Reference:=activesheet.range("a1")
That doesn't work. It just selects cell A1. Biff "PapaDos" wrote in message ... No need to create "range of range" Application.Goto Reference:=activesheet.cells(1,1) or Application.Goto Reference:=activesheet.range("a1") should work just fine... -- Regards, Luc. "Festina Lente" "T. Valko" wrote: ooops! Disregard the last post. It does in fact work just fine. Thanks, Martin! Biff "T. Valko" wrote in message ... Martin, I tried this: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) I get a run-time error 1004 Let me further explain: A1 contains a defined name like Product1. Product1 refers to cell A100. I have the macro attached to a button. I click the button and are taken to Product1 (cell A100). It works just fine using the R1C1 reference but I'm trying to simplify it for others who may be confused seeing R1C1. P.S.: the line of code I posted was generated by the macro recorder. Application.Goto Reference:="INDIRECT(R1C1)" Thanks Biff "Martin Fishlock" wrote in message ... Biff, Goto requires a range object. There you need to do the following: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Cells(1, 1)) 'or Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) But it may be easier just to do thew following: range(ActiveSheet.Range("A1")).select -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "T. Valko" wrote: Hi folks! Application.Goto Reference:="INDIRECT(R1C1)" Why won't that accept an A1 reference? Both of these fail: Application.Goto Reference:="INDIRECT(A1)" Application.Goto Reference:="INDIRECT("A1")" Thanks Biff |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
A1 reference style
Ok, that works!
Thanks Biff "PapaDos" wrote in message ... LOL Sorry, I misunderstood your need. The fact that "INDIRECT(R1C1)" does work is a major surprise for me ! Then, a construct like this one would work too: Application.Goto Reference:="indirect(" & range("a1").address(,,xlR1C1) & ")" -- Regards, Luc. "Festina Lente" "T. Valko" wrote: Application.Goto Reference:=activesheet.range("a1") That doesn't work. It just selects cell A1. Biff "PapaDos" wrote in message ... No need to create "range of range" Application.Goto Reference:=activesheet.cells(1,1) or Application.Goto Reference:=activesheet.range("a1") should work just fine... -- Regards, Luc. "Festina Lente" "T. Valko" wrote: ooops! Disregard the last post. It does in fact work just fine. Thanks, Martin! Biff "T. Valko" wrote in message ... Martin, I tried this: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) I get a run-time error 1004 Let me further explain: A1 contains a defined name like Product1. Product1 refers to cell A100. I have the macro attached to a button. I click the button and are taken to Product1 (cell A100). It works just fine using the R1C1 reference but I'm trying to simplify it for others who may be confused seeing R1C1. P.S.: the line of code I posted was generated by the macro recorder. Application.Goto Reference:="INDIRECT(R1C1)" Thanks Biff "Martin Fishlock" wrote in message ... Biff, Goto requires a range object. There you need to do the following: Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Cells(1, 1)) 'or Application.Goto Reference:=ActiveSheet.Range(ActiveSheet.Range("A1 ")) But it may be easier just to do thew following: range(ActiveSheet.Range("A1")).select -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "T. Valko" wrote: Hi folks! Application.Goto Reference:="INDIRECT(R1C1)" Why won't that accept an A1 reference? Both of these fail: Application.Goto Reference:="INDIRECT(A1)" Application.Goto Reference:="INDIRECT("A1")" Thanks Biff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Discussion (Misc queries) | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) |