• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Property

S

Shay A

Member
Hi,
Could anyone explain me, the concept of R1C1? And with that respect, what do the squared brackets mean?

TY!
 
Hello,
Thanks for the informative link. Taking this a bit further, how do I incorporate to functions when writing a VBA code? Lets say I have a column to till up with the help of VLOOKUP. Theoretically, how would the arguments would look like?

TY
 
Hi,
This is the code and I also uploaded a file.
TY!

Range("B2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],R2C6:R3C7,2,0)"
Selection.AutoFill Destination:=Range("B2:B20")
Range("B2:B20").Select
Range("B2").Select
 

Attachments

  • rset5yse5yreyse.xlsm
    7.7 KB · Views: 4
Hi ,

So what is the problem that you are looking for help on ?

Is the code not doing what you want it to do ? If so , what is it that you want the code to do ?

Unless you are willing to explain your requirement in detail , nothing much can be done.

Narayan
 
Hello,
There isn't a problem, I just wanted to see how does the relative and absoloute refrening work when recording a macro. R1C1 style is the default style when recording?

TY
 
You must log in or register to reply here.
Back
Top