PDA

View Full Version : Pivot table empty



Nmarkit
09-10-2013, 06:45 AM
Hello

Is there anyway in vba to check if a pivot table on another worksheet is empty? I need to basically show up an error if a pivottable i am referencing to create graphs based on user selection, is empty.. as in the user has selected a combination that has no corresponding data within the pivot. i want to show up a message saying error or something in such a scenario. how can i go about doing this?

Thanks!