ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   R1C1 in Excel 2003 VB (https://www.excelbanter.com/excel-programming/309133-r1c1-excel-2003-vbulletin.html)

loopy[_5_]

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


Tom Ogilvy

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/





All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com