Hi jassie,
All of what you've described is possible, but you haven't given enough details for anyone to suggest any code for it. FWIW, using a macro (and even without one), you can copy the contents of hidden columns/rows without unhiding them.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|