Need to Create Macro Button That Hides Empty Columns ONLY when Rows are Filtered

[asoule519]

Hello everyone!

I am relatively new to VBA / macro coding so I am in desperate need of your help!

I have a spreadsheet showing product SKU's, their everyday retail price and the promo price they had during specific promotions. There are a lot of empty columns because not every product is included in every promotion. I have added a command button in the top right corner of the sheet that is titled Hide / Unhide Blank Columns.

My goal is that when the command button is clicked, ONLY the blank promotion price columns will be hidden (not deleted, just hidden).

This is what the spreadsheet looks like with no filters:

FIGURE 1
Hide Blank Columns 1.PNG

When the data is filtered to show only 1 SKU at a time, I need the button to hide the empty columns (essentially go from FIGURE 2 to FIGURE 3)

FIGURE 2
Hide Blank Columns 2.PNG

FIGURE 3
Hide Blank Columns 3.PNG

The current coding I have linked to the command button is as follows:

Please Login or Register  to view this content.

Any feedback you have would be greatly appreciated!

~ Ashley

[jmac1947]

Hello Ashley and welcome to the forum.
It will always help your query if you include the spreadsheet / workbook that you are trying to "manipulate". Most of us are "time poor" and unless the solution is very very obvious we don't have the time to build a spreadsheet to investigate possible solutions.

Forum members are generally very helpful and often extremely knowledgeable in all manner of excel / VBA solutions.