Results 1 to 2 of 2

Thread: Function acts as if it's volatile but it isn't

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,232

    Question Function acts as if it's volatile but it isn't

    There's a Public function in a workbook of mine (that I can't post here) that gets executed repeatedly every time the workbook is calculated even though there's no Application.Volatile or for that matter "volatile" anywhere in the code. It occurs for example when I make a copy of any sheet in the workbook. There's also no code in the Thisworkbook object or the copied sheet and there's no call to the function anywhere in the workbook. Any ideas why this might be happening?

  2. #2
    Fanatic Member
    Join Date
    Feb 2013
    Posts
    985

    Re: Function acts as if it's volatile but it isn't

    I would guess the function is used inside the sheet on a formula, and the calculations are triggering it.
    Yes!!!
    Working from home is so much better than working in an office...
    Nothing can beat the combined stress of getting your work done on time whilst
    1. one toddler keeps pressing your AVR's power button
    2. one baby keeps crying for milk
    3. one child keeps running in and out of the house screaming and shouting
    4. one wife keeps nagging you to stop playing on the pc and do some real work.. house chores
    5. working at 1 O'clock in the morning because nobody is awake at that time
    6. being grossly underpaid for all your hard work


Posting Permissions

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



Click Here to Expand Forum to Full Width