R1C1 in Excel 2003 VB

  • Thread starter Thread starter loopy
  • Start date Start date
L

loopy

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 vs Excel 2007 #N/A in VB 4
Excel 2003 VB referencing #N/A not working but works in Excel 2007 1
Excel 2007 Macro and VB Buttons 1
I cannot record a macro in relative mode. The button never shows. 1
Using R1C1 in VB to select a range 2
relative reference pivot table macro 2
Solver Compiler issue 2
VB password lost 3

Back
Top