Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine if value in pivot table
hi,
I have a combobox with a list of value in sheet1. and wen i make a selection it performs the followig: sheeta("pivot").range("C6").value = sheets("lookup").range("B4").value i would like to know if there is any kind of way to add some code to determine whether or not the value selected via the combobox exists in te pivot table BEFORE the preceding code is executed. this is to prevent the "x value does not exist.. rename x to y". thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
determine in datasource or pivot table | Excel Discussion (Misc queries) | |||
determine the name of the selected pivot table | Excel Discussion (Misc queries) | |||
How to determine order of row fields in pivot table | Excel Programming | |||
Determine If Pivot Table Exists | Excel Programming | |||
Determine the location of an external source of pivot table? | Excel Worksheet Functions |