J
JC
I am trying to use a VLOOKUP function within a macro. The
code I am currently attempting to use is:
VLOOKUP(RC3,'LMon & " CF"'!R8C3:R260C27,'LMon & " CF"'!R[4]
C[11],0)
where LMon is a defined variable that holds name of the
previous month. For example "Dec CF" is one of the sheets
in my workbook.
With the syntax above I am getting a Compile Error. Can
someone tell me how this shuld be correctly written.
TIA,
JC
code I am currently attempting to use is:
VLOOKUP(RC3,'LMon & " CF"'!R8C3:R260C27,'LMon & " CF"'!R[4]
C[11],0)
where LMon is a defined variable that holds name of the
previous month. For example "Dec CF" is one of the sheets
in my workbook.
With the syntax above I am getting a Compile Error. Can
someone tell me how this shuld be correctly written.
TIA,
JC