Doyle_D shared this with us in microsoft.public.excel.programming:

Let me put it another way. I want to be able to merge cells that are
not adjacent to one another....not necessarily on the same tab, or
not even necessarily on the same spreadsheet for that matter. Can it
be done?

I understand exactly what you mean.
Your question clearly demonstrates a misinterpretation of the
fundamental concepts of both a database (Access) and a spreadsheet
(Excel).

You think you see cells with values in Access. This is not true. What
you really see, is the result of a query. A query is a representation
of (a part of) the internal database. You (almost) never see the
database itself.

Think of a big cardboard box. Access is a big box with data inside, and
what you see (using a query) is what you can see through a hole in the
box. Different shapes, sizes and positions of holes give you different
views of what is essentially the same data.
You can also use the holes to put new data in. If you simultaneously
look through another hole, it may /appear/ that the data is also
inserted there, but that is not true. You see what has happened
elsewhere, just from another angle.

Now comes Excel. This is not one big box, but thousands and thousands
of small boxen (worksheet cells) all stacked together. If you change
one cell, you put something in one box. It's only in that little box
and not in another box.


I hope this metaphore clears up some misunderstandings.


What you need/want, is an access database backend (the big box) with
queries (holes in the box) and an excel worksheet frontend (reach
inside the big box through the hole and put it in a small box)

--
Amedee Van Gasse using XanaNews 1.17.4.1
If it has an "X" in the name, it must be Linux?