Macro for Slicer for Month's not yet visable

[jnco903]

Hi all,
Thanks in advance for your help. I am new to VBA and have a question. I have a macro that will get a value from a hidden pivot table based on a data validation cell. The purpose of this worksheet is to automate our Trial Balance. The marco is working perfectly right now, however I don"t want to keep updating the macro every month to include the new months that will be coming through the pivot. For example right now we don't have months 9-12 in the GL because they are in the future. My current Macro can only look at the current items in the GL; so every month I will have to go in and add a line like .SlicerItems("9").Selected = False (It's false because the macro below is for March's Trial Balance). I would like to add a statement to the macro, like still look for periods 9-12 but if not available then ignore and if available set to False (March's Marco).

Is there a way to do this?

Also, please note I am using a slicer to filter the data in my macro.

Please Login or Register  to view this content.

[Cutter]

@ jnco903

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.