Compile error: Expected end of statement

[RoOmIE]

Please Login or Register  to view this content.

i want to put the counters in the [] brackets but i get a compile error expected end of stantement

[ragulduy]

you need to add & signs when switching from strings to variables in your formula definition:
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[" & count1 & "],Sheet1!C[" & count1 & "]:C[" & count2 & "],5,FALSE)"

[RoOmIE]

thanks yudlugar ... now if i want to change sheets at every count .. how would i do this ..

[RoOmIE]

Please Login or Register  to view this content.

this is sort of what i want to do ..

[ragulduy]

Please Login or Register  to view this content.

?

[RoOmIE]

Thanks.. i am somewhat not used to the language of vba .. but am learning .. thanks a lot!