miketastic
New Member
- Joined
- Apr 8, 2015
- Messages
- 14
Hello,
I have set up a dynamic print range via the Name Manager with the following formula:
=OFFSET('WIRES'!$A$1,0,0,COUNT('WIRES'!$E:$E)+5,6)
The formula works fine, but when I use it (both directly as the Print_Area and as a separate Name for Print_Area to refer to) the formula disappears and only the calculation is left. I can't get the formula to stick so that it actually is dynamic.
Any help is CRAZY appreciated!
Thanks
I have set up a dynamic print range via the Name Manager with the following formula:
=OFFSET('WIRES'!$A$1,0,0,COUNT('WIRES'!$E:$E)+5,6)
The formula works fine, but when I use it (both directly as the Print_Area and as a separate Name for Print_Area to refer to) the formula disappears and only the calculation is left. I can't get the formula to stick so that it actually is dynamic.
Any help is CRAZY appreciated!
Thanks
