Good day folks,

I have this code:

termmon = Month(Sheets("Main").Cells(9, 3)) + 1
Range("J30").Select
ActiveCell.FormulaR1C1 = "=HLOOKUP(""5 Days"",R[0]C[-8]:R[18]C[-2],
termmon, FALSE)"

When I try to use the variable "termmon" in the hlookup formula, I get
the #Name? in the active cell. I tried to copy and pastevalues in the
active cell but still the same thing happen. Do anyone know if there
is a way to get this to work?

Thank you

Chris


--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile: http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=517293