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
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.
Delete all grouped rows and columns in active worksheets in a workbook
Hello awesome ppl, I am trying some VBA codes to delete all the grouped rows and columns from active sheets of the excel workbook. The code is attached, however it is not working fine. Also can it be done something like i simply run the macro and magic is done. the current code give "OK"...
chandoo.org
Thanks,
Vivek
Last edited: