Results 1 to 3 of 3

Thread: reset vba vs. macro
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2005
    Location
    Avalon
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default reset vba vs. macro

    on one of my sheets I have values returned from a series of formulas. Can someone give me some direction on how to tell a button I added in to clear all the values from those results?

    I tried doing this via record macro with no success. I dont want to lose my formulas (they're linked to several other pages), just the values. The cell range affected is b3 to h26 if this helps.

    I know this is elementary but so am I....

  2. #2
    MrExcel MVP Richie(UK)'s Avatar
    Join Date
    May 2002
    Location
    UK
    Posts
    3,329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Eddie,

    OK, you want to clear the result of the formula but not delete the formula itself, right?

    Seems to me that the only way to do this is to clear the values in the cells that are used by the formulas. (Or, possibly, do delete the formulas themselves but have a macro that reinserts the formulas when you wish).

    What is your objective (ie. why do you want to clear the values)?
    Richie

  3. #3
    Board Regular
    Join Date
    Jul 2005
    Location
    Avalon
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    my end objective is to clear out my sheet so that the next request will re-populate with new information.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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