Excel 2007 : Use a variable instead of a hard coded value

Hi folks,

This should be an easy one.

Below is a line of code that works fine:

Please Login or Register  to view this content.

But instead of the hard coded value 6725, I want to use my variable LastRow (Dim as Integer).

How should I format the new code? I have tried simple things like:

Please Login or Register  to view this content.

And I get '1004' errors.

Can you folks tell me how to do this right, or if not "right" just so it will work?!

- Thomas

You were close:

Please Login or Register  to view this content.