| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Added apostrophes from VBA to Excel??
Does anyone know why this code
ActiveCell.FormulaR1C1 = "=HLOOKUP(A20,RC[1]:RC[100],1,FALSE)" becomes this in the cell once inserted =HLOOKUP('A20',RC[1]:RC[100],1,FALSE) and the "added" apostrophes to cell ref 'A20' instead of A20 prevent the A20 text from being found by the HLOOKUP. If after inserted I manually remove the apostrophes, the command works properly. How can I prevent VBA from adding these apostrophes?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| apostrophes | Excel Discussion (Misc queries) | |||
| Apostrophes and Sorting | Excel Discussion (Misc queries) | |||
| How do I remove leading apostrophes in Excel? | Excel Discussion (Misc queries) | |||
| Apostrophes instead of equals in Excel | Excel Worksheet Functions | |||
| How do I obtain Curly quotes and apostrophes in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
