+ Reply to Thread
Results 1 to 3 of 3

Keeping numbers constant

  1. #1
    Registered User
    Join Date
    12-21-2014
    Location
    somewhere
    MS-Off Ver
    2010
    Posts
    36

    Keeping numbers constant

    I am making a function and it currently looks like this

    Please Login or Register  to view this content.
    My problem is that the value of SourceOneFwd changes from before VolOne to after VolOne. I do not want the value of SourceOneFwd to change.
    Can anybody help me

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Keeping numbers constant

    If you've set the value of a variable then it won't change until you set it again, somewhere else in your code you you must be setting it again
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Keeping numbers constant

    I assume the 'second' function changes SourceOneFwd. If you don't want that change reflected outside of the 'second' routine, change it to accept that argument ByVal.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. keeping the value of a cell constant
    By mojojojo_excel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-11-2013, 04:29 AM
  2. Keeping chart size constant
    By agricola in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-05-2012, 05:00 AM
  3. keeping formula constant
    By ajcrew in forum Excel General
    Replies: 4
    Last Post: 04-03-2012, 10:18 PM
  4. keeping one cell constant
    By Malcolm in forum Excel General
    Replies: 1
    Last Post: 07-10-2006, 09:34 PM
  5. Replies: 0
    Last Post: 03-27-2006, 11:55 PM

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