Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving a Value from one run to another (MSOFFICE97 SR2)

    Hi:
    In my VBA code, how would I read the value in a cell, say E1, and save it so that the
    next time I ran the same code I could compare the value that would currently be in cell E1
    with what it was the last time I ran the code?
    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a Value from one run to another (MSOFFICE97 SR2)

    Put the value in cell E1 into another cell somewhere in the workbook. It could be in a hidden worksheet. You will have to make sure that the workbook is saved after you put the value into the other cell.
    Legare Coleman

Posting Permissions

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