cell address copy

[ccsmith]

I have a short sample file contains 2 WS. 2nd. WS contains data (col. B.) and cell reference (col A).
I need to use reference address in cell ("A" & i) to copy data of cell ("B" & i) to the first worksheet into the cell address I found ("A" & i) .
Please give me a support and let me know where I made mistake in the following code.

Please Login or Register  to view this content.

[gmr4evr1]

Add the word Set before the s = and r = and it should work. Also change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

New code

Please Login or Register  to view this content.

[ccsmith]

Thanks. I really missed the Set. I appreciate your help.

[gmr4evr1]

Not a problem, you're welcome. Glad it worked for you.