| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup and using single quote
I'm trying to code this piece:
..Range("Z" & NewRow2 & ":Z" & NewRow2).Formula = _ "=IF(ISNA(VLOOKUP($A6,INDIRECT(" '["&Y2&"]By_Rep_by_Filter'!$F$1:$P$5000"),11,FALSE)),""""," & _ "VLOOKUP($A6,INDIRECT("'["&Y2&"]By_Rep_by_Filter'!$F$1:$P$5000"),11,FALSE))" But the single quote (') in the INDIRECT("' is causing everything after that to be treated like a comment. How do I get the code to treat it just like a regular character and not a comment? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Single Quote use in cell reference | Excel Worksheet Functions | |||
| How do I display a single quote in a cell? | Excel Discussion (Misc queries) | |||
| Annoying single quote with ever new workbook | Excel Discussion (Misc queries) | |||
| using a single quote ' in SEARCH function | Excel Worksheet Functions | |||
| Remove single quote | Excel Worksheet Functions | |||
Threaded Mode
