renderman7
New Member
- Joined
- Oct 27, 2011
- Messages
- 10
Hi all,
Hopefully someone can help.
I have code to turn off some pivot table options, and it works fine.
However, turning on is causing to be a pain, as one of the data options does not appear each day.
Example.
Option 1
Option 2
If Option 2 is not in the list for todays report, but i have the code to say turn it on, and its not there, the code fails.
Is there a way to say if Option 2 is not listed, move on?
Sorry if this is confusing.
Hopefully someone can help.
I have code to turn off some pivot table options, and it works fine.
However, turning on is causing to be a pain, as one of the data options does not appear each day.
Example.
Option 1
Option 2
If Option 2 is not in the list for todays report, but i have the code to say turn it on, and its not there, the code fails.
Is there a way to say if Option 2 is not listed, move on?
Sorry if this is confusing.
