I have a report spreadsheet that has a macro to "Print and Save" the
spreadsheet. I also have a macro to adjust the height of merge cells
with text wrap when the text is not seen in the spreadsheet. The way
this macro is set up is that it only can be run with the highlighted
merged cell. First I would like to make this height macro look at all
the merged cells that have text not seen on the spreadsheet and I would
like to put this macro inside my "Print and Save" macro, so it will
open all the merge cells that need it before printing out the
spreadsheet. Thanks for any help.

If you want someone to modify your macro, then you probably need to post
your macro.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I have a report spreadsheet that has a macro to "Print and Save" the
spreadsheet. I also have a macro to adjust the height of merge cells
with text wrap when the text is not seen in the spreadsheet. The way
this macro is set up is that it only can be run with the highlighted
merged cell. First I would like to make this height macro look at all
the merged cells that have text not seen on the spreadsheet and I would
like to put this macro inside my "Print and Save" macro, so it will
open all the merge cells that need it before printing out the
spreadsheet. Thanks for any help.