Excel Macro Quick Question

[MakeItSo]

Hello Everyone,

I was wondering if anyone could help me out with the "programing" of a section of my macro.

I created a macro by recording a set of actions but hadn't realized that the sections I was changing were dynamic, meaning that some weeks the information is there, some weeks it's not.
What the macro does is basically take the raw data file and turn it into a pivot table.

When I run my macro the following error comes up in yellow on the Debugger:

ActiveSheet.PivotTables("PivotTable3").PivotFields("Sub Category Name"). _
PivotItems("Request my data").ShowDetail = False

Is there any way that I could program the macro to skip this section "Request my data" or any other sections if they're not present in the raw data and still complete the pivot table with the information that is present?

Thanks in advance for your help!

 

[Dermot]

You need to use an IF test in your code, to check if a certain section is there or not, ie

If **** Then
  'the info is there, extract it
End If

so you need to figure out how the code can decide if the data is there or not

 

[MakeItSo]

Thank you Dermot for your help!

Would you be able to create the IF statement for using the example piece of code I posted above so I can visualize it better?

Trying to figure out how I would implement that in the code.

Thank you in advance for your help with this

 

[Dermot]

you need to first figure out how you know a section is missing, eg D5 is blank or something

 

[MakeItSo]

I see.

Unfortunately there wouldn't be a cell that's empty, it would just be that this specific category will not be in the report.

Don't know if that is possible

 

[Dermot]

Well, how is VBA supposed to know if it's there or not?
Until you figure that out, it's impossible to do what you want