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!!
 



Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  Insert an Apostrophe in a formula - arad lahiji  08-May-08 5:24:13 PM
      Re: - Aravind Kumar  09-May-08 12:51:33 AM
      try this code! - sundar k  09-May-08 1:39:18 AM
View Posts