Use a variable in Range.Formula

[jewelsharma]

How to use the current value of a variable in Range.Formula?
I need a macro to reset a sheet; wherein amongst other things, I need to insert a formula in every alternate cell (say from B2 to B10) that checks a condition based on the adjacent cell in Column A.
I tried the following code, but it inserts the text "iRow" instead of it's value.

Please Login or Register  to view this content.

Warm regards,
Jewel

[Pete_UK]

Try it like this:

Please Login or Register  to view this content.

Hope this helps.

Pete

[Izandol]

You may also use:

Please Login or Register  to view this content.

[jewelsharma]

Pete_UK, Izandol,
Many thanks for your prompt support.

Warm regards,
Jewel