= sign error

[kenpcli]

I have this code: but when I hover over Payday it shows Payday = "="08-05 TO 08-11" and the code stops.

Payday = Application.InputBox(Prompt:="What is the Pay Period?", Type:=0)
ThisWorkbook.Sheets("HOURS BY ID").Range("G2:G1500").FormulaR1C1 = _
"=IFERROR(VLOOKUP(G2," & Payday & "$C:$Q,15,0)"

 

[Kenneth Hobson]

When building a formula, I like to do it manually first. Then, I comment it above the code line where I build the string. I then use Debug.Print to print a Run's result into VBE's Immediate window.

I don't what formula you expected from the input box or the input value. After the inputbox I would:

Debug.Print Payday

I don't know why you set R1C1 format the formula but used A1 format for its string assignment.

 

[kenpcli]

I must be going about it wrong. What I am looking to do is add whatever tab name the user enters into the formula and copy down that column.