Results 1 to 9 of 9

Thread: [RESOLVED] problem with ' in a formula

Threaded View

  1. Jun 4th, 2006, 07:43 AM #1
    engnouna
    engnouna is offline

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2006
    Posts
    977

    Resolved [RESOLVED] problem with ' in a formula

    Hi
    I want to write a formula into a cell
    I used the following code:
    oXLSheet.cells(20,2).Formula="=SUMPRODUCT(COUNTIF(INDIRECT('Sheet1'!D2:D100"),"*Economics*"))" but it considered ' as a comment so only =SUMPRODUCT(COUNTIF(INDIRECT( is considered as a formula.('Sheet1'!D2:D100"),"*Economics*")) is colored in green like a comment.
    How can I deal with this problem
    thanks
    Last edited by RobDog888; Jun 4th, 2006 at 09:09 AM. Reason: Disabled smilies in this post
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width