Announcement

Collapse
No announcement yet.

Can not use stdeva in excelmacro,please help

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can not use stdeva in excelmacro,please help



    this line is giving me an error,please help me to troubleshoot

    ActiveCell.Formula = "=STDEVA(range(" & """" & area & """" & ")"

    here area is a string variable which is having the value it supposed to have just fine

    So the main issue is syntax and more specifically the quotation marks I guess,any help is appreciated

    Thank You
    Sourav Bhattacharya

  • #2


    CROSS POST



    This question has been posted in at least one other forum.

    Do not post any further responses in this thread until a link has been provided to these cross posts.



    Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why.



    This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. Itís never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.

    Please provide the link(s). If you are unable to do so, tell us where else you have posted this query.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    Comment

    Working...
    X