How to insert a variable or formula in a cell definition

Hi

I am new to macros... am trying to insert a variable or a formula in a cell definition, e.g., instead of

Please Login or Register  to view this content.

which refers to a cell relative the the active cell, have something like this

Please Login or Register  to view this content.

where i is a variable rather than a constant (the number of cells in my original, non-log-transformed data). If I try to run this I get a "run time error '1004', Application-defined or object-defined error".

Below is the code itself
Thanks
Daniel

Please Login or Register  to view this content.

You've tried to embed your variable i, in a string. Separate it out and concatenate, thus:

Please Login or Register  to view this content.