Hi Mike,

If you used the macro recorder, was the referencing absolute or
relative?
If it was relative, then what is copied and where it is pasted depends
on the address of the selected cell when you ran the macro.
If it as absoute then it will always be B3 copied /pasted into F6 for
macro1 and B4 copied/pasted into F7 for macro2

Ken Johnson