I not understand you

If you create the links in row 50 to the cells (in the order you want ) you only have to
change the range to A50:C50 in this example
http://www.rondebruin.nl/copy1.htm#workbook

And you can hide row 50 so you not see it

--
Regards Ron De Bruin
http://www.rondebruin.nl



wrote in message ups.com...
Ok I have changed the Range from A1:A6 to A50:C50. As for where to
place the

In A50 =A3
In B50 =D5
In C50 =C4

formulas in the code, that am a bit confused. If you couldd paste
exactly where is supposed to in the code that will be helpful. Also for
the "In"statement i think it requires some sort of declaration before
it like the "For" statement, but this im not too sure.

Dwight