1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Simple Excel Macro Help

Discussion in 'Business Applications' started by Sealtrans, Mar 8, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. Sealtrans

    Sealtrans Thread Starter

    Joined:
    Mar 8, 2007
    Messages:
    3
    Perhaps it's too simple for me to understand...or I'm .....

    I want to create a manual macro that will allow me to add 85 to whatever value may currently be in the cell. Nothing automatic...no if/then scenario.

    One of those things that I can normally do with my eyes closed but can't seem to make work.

    Any help would be appreciated.
     
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,445
    If "the cell" = the active cell, then

    Sub Plus85()
    On Error Resume Next
    ActiveCell = ActiveCell + 85
    End Sub
     
  3. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Why use a macro for this? Type 85 in a cell, select that cell, copy it. Select "the cell" in question, paste special | add.
     
  4. Sealtrans

    Sealtrans Thread Starter

    Joined:
    Mar 8, 2007
    Messages:
    3
    I have about 10,000 pricing fields and wanted a one-step option to increase our price $85.00.
     
  5. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    So select all of the cells when pasting special. This shouldn't be too difficult to do by hand and should only take a few seconds.
     
  6. Sealtrans

    Sealtrans Thread Starter

    Joined:
    Mar 8, 2007
    Messages:
    3
    I guess I'm not being clear...I'm not changing all the fields...just specific one's based on some outside paramenters. The macro I got above works great! Thanks.
     
  7. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    And what, do this 10,000 times?! You'd be better off adding a helper column with a formula with matching criteria and filtering that way. If your data structure was put together well, it shouldn't be that big of an issue. Maybe it'd be a good time to re-think the way your data is structured..
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/550089

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice