try this code!

sundar k replied to arad lahiji at 09-May-08 01:39
I think you can just try,
ActiveSheet.Range("B66").Formula = "=pull(mfpn & wsn & ct)"
 I am seeing a exclamation before your ct , do you want to negate the ct and put it as a formula? in that case  you can change ct in  your forumula as not(ct).

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 05:24 5:24:13 PM
      Re: - Aravind Kumar  09-May-08 12:51 12:51:33 AM
      try this code! - sundar k  09-May-08 01:39 1:39:18 AM
View Posts