Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    1

    Unanswered: run macro from a selection

    Hi guys. This is my first post, so I hope you can help. I just got put in charge of a huge rat database, and I need to run a lot of reports in excel. I have to copy about 100 rows in a sheet of over 2000 entries and paste it into a new sheet and then run a macro to reformat the sheet and print it out. I would like to be able to select the rows and run the macro only on those rows and none of the others. Is this possible. I have searched around and don't think so, but hopefully I am wrong. Thanks. anne

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy, Anne, and welcome to the board.

    Yes, it is possible. But you would need to give more specifics.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    May 2008
    Location
    Australia
    Posts
    1
    Hi Goldie6175,

    First create a new copy of your original xls file and then experiment.
    Try to create a record macro you may want to try to press Alt-T-M-R record the action you wish to perform and then debug it later using Visual Editor.
    If you are happy with the result then rerun the program to attain what you wish to do. Hope this helps.

Posting Permissions

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