Nigel,
I got that working. Thanks for your help
it was a question of referencing the proper cell of the nine merged
cells. If i paste to the upper left corner, then it will paste
properly, so i had to write a few extra lines, if x = 1 then (0,4)....
if x = 2, then (-1, 4) or whatever, you get the point.

thanks for your help though. i'm learning a lot.

jasonk






On Thu, 16 Mar 2006 10:21:02 -0000, "Nigel"
wrote:

Generally you do not need to use select - activate or copy-paste, by
referencing the cell(s) directly you can assign a value to / from a
variable. It is faster and will overcome the merged cell reference problem
you are having. The problem is that you probably have a mixture of
cut-paste / assignments and that is throwing the errors.

As I said post your section of code and someone can advise on what to do.