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 |
All times are GMT +1. The time now is 05:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com