• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Single macro to run some excel tasks in order

vivekdabodiya

New Member
I would appreciate if anyone can provide with one single macro to do following in order:-

For active worksheets:-
1. Value paste all data in the cells.
2. Delete all hidden rows and columns.
3. Delete all grouped rows and columns.
4. Delete data outside print area.

For entire workbook:-
1. Value paste all data in the cells.
2. Delete all hidden rows and columns.
3. Delete all grouped rows and columns.
4. Delete data outside print area.

Some codes which were collected for these operations can be found at below link. Hoping these might help in building the one as per requirement.


Thanks,
Vivek
 
Last edited:
Rather than a guessing challenge please better do the necessary according to forum rules​
in particular within How to get the Best Results :​
 
Back
Top