Insert an Apostrophe in a formula |
| arad lahiji posted at 08-May-08 05:24 |
This is probably a really dumb question but im new to this. I'm trying to put in a code for VB to automatically insert a formula into a specific cell. My formula has an apostrophe in it because it refers to another workbook... ActiveSheet.Range("B66").Formula = "=pull(" '"&mfpn&wsn&"'!"&ct)" MFPN, WSN, and CT are all cell references, not variables. So basically I want that whole quote to be inserted into the cell.
Everything after the first apostrophe is converted into a comment...Is there a work around?
please help!! |
|