HI
I have an excel file when apply pivot, often appear blank rows . I do not want has any blank row with macro or .....
thank from help.
HI
I have an excel file when apply pivot, often appear blank rows . I do not want has any blank row with macro or .....
thank from help.
Hello habib100,
You can remove work 'Blank' from pivot table very easly. Select the column where word blank is coming, go to edit and select replace now in Find write (Blank) and in replace just press tab button two times then ok..... now you can see blank is removed from the pivot.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
no,I need a command with macro
Hello habib100,
Enter the Code below in a Standard Module;
Create a Button on the relevant Sheet and assign the Macro above to that Button.Please Login or Register to view this content.
See attached sample Workbook.
Last edited by Winon; 10-18-2019 at 04:42 PM. Reason: Changed Code
Hello Winon
thank, but Those rows don't disappear with this code?
I Would remove this rows that shown in example file.
Hello habib100,
It would seem that one cannot delete a Row from a Pivot Table.
The best I could do is:
Regards.Please Login or Register to view this content.
Hello Winon
Thank , ok If I want to put this button in Sheet 1, how the code changes?
Hello habib100,
Copy the first Sub DelBlank(), paste below it, and rename it.
Now change Sheet2 to Sheet1 and ensure you reference the correct PivoFields applicable to Sheet1.Please Login or Register to view this content.
Create a Forms Button on Sheet1 and assign the Macro above to that Button.
Hello Winon
Solved
thanks...........
You are welcome habib100,
Glad I could help and thank you for the Rep+. I appreciate it.
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks