hey Guys, so I am trying to automate this report using macros, and When I come to use vlookup, it puts the code as ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-12],References[#All],2,0)"
This works for one of my sheets, but it wont work for all of them as new columns will be added with each update. is there a way for it to reference the cell "$A2" every time instead of me having to re write a code calculating how many rows and columns away it is.
I also tried putting in R2C1 instead of the RC[-12] but that fixes the references. I need it to be $A2, not $A$2
any and all help would be greatly appreciated!
This works for one of my sheets, but it wont work for all of them as new columns will be added with each update. is there a way for it to reference the cell "$A2" every time instead of me having to re write a code calculating how many rows and columns away it is.
I also tried putting in R2C1 instead of the RC[-12] but that fixes the references. I need it to be $A2, not $A$2
any and all help would be greatly appreciated!
