VBA insert formula

[diablo86]

Hello....

Bit of a basic question from what i understand, however im having major difficulty in doing this.

What i am trying to do is insert the following

Please Login or Register  to view this content.

into D2 and the relevant code going down to D1000 so would result in

Please Login or Register  to view this content.

, i thought this could be done using something like

Please Login or Register  to view this content.

but not had any luck.

Any help you could give would be greatly appreciated.

Thank you in advance
Michael

[JosephP]

simply

Please Login or Register  to view this content.

[diablo86]

Amazing thank you

[codeslizer]

Or just change your code from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.