Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
R1C1 in Excel 2003 VB
I have added the stop recording tool bar to get the relative referenc
button. whether I have the button selected or not, i get relative reverances i the VB script when auto recording. I need to turn of relative, and cant! your help is appreciate -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
R1C1 in Excel 2003 VB
sounds like you are confusiong relative/absolute referencing with R1C1 style
referencing. There is no recording mode that records in R1C1 style. Some actions are recorded as R1C1, but most are recorded as A1 style. In any event, it shouldn't make any difference in being able to executing the code. -- Regards, Tom Ogilvy "loopy " wrote in message ... I have added the stop recording tool bar to get the relative reference button. whether I have the button selected or not, i get relative reverances in the VB script when auto recording. I need to turn of relative, and cant! your help is appreciated --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Discussion (Misc queries) | |||
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Worksheet Functions | |||
Excel - columns described R1C1, R1C2 | Excel Discussion (Misc queries) | |||
R1C1 Formula in Excel | Excel Worksheet Functions | |||
Excel help should explain how to change r1c1 to a1 | Excel Discussion (Misc queries) |