John Michl
4/30/2004 9:47:00 PM
I need to create a dynamic print range that automatically adjusts based on
the size of a pivit table. The rows to repeat at top are static and
include the top of the pivot table but the length and width need to adjust.
I've tried using a named range that includes the offset function but Excel
seems to replace the formula or named reference with the actual references
so it doesn't stay dynamic.
Any ideas?
Thanks - John