Hi all,

I'm new to trying to write a macro without using the recorder, so I hope this isn't a very complicated question, I don't think it is.

Here is my problem.

I have Worksheet1 in which "C8" is linked to "CU8" on Worksheet2. What I want to do is have a macro that will auto increase the link on Worksheet2 by one column so the new link in "C8" Worksheet1 will be "CV8"Worksheet2. What would be the VB code to do this?

Thanks
Mickey