Dynamic macro

Hello.

I have this macro:

Please Login or Register  to view this content.

How can I make this more dynamic the easiest way?

/Anders

Please Login or Register  to view this content.

B36 should be the cell in the column to the right after:

Please Login or Register  to view this content.

Does this help?

/Anders

Hello.

It worked great. Thanks!
Later in the code I need the information once again.
I need to change

Please Login or Register  to view this content.

to a dynamic version like this i guess.

Please Login or Register  to view this content.

What is wrong? Excel tells me "Expected list separator or )"

/Anders

The error is in the location of the "

should be

Please Login or Register  to view this content.

NEver use a $ symbol on a variable that is to hold numeric information. The $ symbol changes the variable to a string variable

Thank you.

How about this one?

Range("A36:T36").Select

How do I make it dynamic?
Range ("A"&i:T"&i).Select

/Anders

Thank you both!

I am also Glad you fixed your problems ...

Thanks for the feedback

Hi,

Could you please tell me where do you add or replace the above code in the source code.
I am trying but it doesnot work.

Thanks