Variable Referencing problem

[jbesant]

Hi everyone:

I am using the vba code below to input a formula into excel cells. However, I want to make the "A:A" and the "D3" in the formula relative to the variable c2 (which is an integer). Does anyone know how to do this?

Cells(3, 3).Offset(0, c2) = "=IF(COUNTIF(" & "A:A" & "," & "D3" & " )=0,""Not Found"",""OK"")"

Thanks so much for your help!

Jamie

 

[jbesant]

When I hit compile it highlights the function name, and gives the following compile error: "Can't find project or library". Then it highlights the first use of chr.

 

[VoG]

Check for missing references http://www.cpearson.com/excel/MissingReferences.aspx

 

[jbesant]

Will do...much thanks for a whole thread worth of help, Peter!