| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and Pivot Table Query for Text values
I think I am having a problem with my code because if the value in a cell is
text instead of numeric, the symbol ' needs to be added to the code. In the code below, where would I put the ' to switch the variable deptNUM from numeric to text? & "WHERE (AC_CLAIM.GL_BUS_UNIT_A_NBR=" & deptNUM & ")") Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table With Text Values | Excel Discussion (Misc queries) | |||
| a query for pivot table | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Query | Excel Discussion (Misc queries) | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
Linear Mode
