Friends,
I have created bill copy in excel format which goes in to multiple sheets. I use separate macro for different sheets to hide blank rows to hide rows in which quantity or amount is 0. Also use another set of macros to un-hide rows in multiple sheets.
What I want-
1) to have one macro to work on multiple sheets (not all) (Predefined in macro) to hide blank rowwithin different ranges in different sheets (Ranges to be defined in macro for each sheet)
2) Un-hide rows in multiple sheets (not all)
3) Create and save pdf print file of multiple sheets in pre-defined sequence (in macro itself) after running macro for hide rows.
Bookmarks