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