Hi:

I thought this would be simple. So far, it isn't.
I need to display a subset of contiguous rows and columns from a
source workbook in a destination workbook. (I've given the range a
name).
The source range will shrink and grow. However the top and bottom
rows will be static as such.
(i.e. the range will grow but not by appending to the last row, it's a
footer.)

Getting the destination to be truely dynamic seems to be the problem.
It seems like allocating additional area for future growth is required
and that area ends up with either #NUM or #VALUE type messages, or
else the 'copy' runs the risk of truncation.

(I don't think I want to use OLE)

Is there an elegant solution?

Thanks in advance, Paul