+ Reply to Thread
Results 1 to 2 of 2

Change cells inside a function

  1. #1
    Guest

    Change cells inside a function

    Hi all:

    I'm writing a function, that search into a given range, 4 cells that
    standard deviations is better, and returns it...

    =DESVESTMIN(A1:A8;4)

    I would like to mark the used cells and here is the problem. It seems that I
    cannot change anything inside a function, is it right ?

    Thanks

    Manel



  2. #2
    Niek Otten
    Guest

    Re: Change cells inside a function

    Hi Manel,

    Yes, that's right. You cannot change anything in worksheets or in Excel's
    settings from within a function that is called from a worksheet, directly or
    indirectly.
    You can in macros and in functions called from VBA. NO, you can't tweak it
    by calling a function from another function that is called from a worksheet
    etc.

    --
    Kind regards,

    Niek Otten


    <Mc_Fly> wrote in message news:[email protected]...
    > Hi all:
    >
    > I'm writing a function, that search into a given range, 4 cells that
    > standard deviations is better, and returns it...
    >
    > =DESVESTMIN(A1:A8;4)
    >
    > I would like to mark the used cells and here is the problem. It seems that
    > I cannot change anything inside a function, is it right ?
    >
    > Thanks
    >
    > Manel
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1