Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I use this formula in my macro:
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[9],ref1,2,FALSE)" Is it possible to add code that will do the lookup in "ref1" and "ref2" ? Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Modifying Sheet1 macro to run on Sheet2 | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |