+ Reply to Thread
Results 1 to 4 of 4

Add statements/Actions to an existing macro

Hybrid View

glenp99 Add statements/Actions to an... 03-03-2010, 05:15 AM
pike Re: Add statements/Actions to... 03-03-2010, 06:46 AM
glenp99 Re: Add statements/Actions to... 03-03-2010, 08:04 AM
pike Re: Add statements/Actions to... 03-03-2010, 05:22 PM
  1. #1
    Registered User
    Join Date
    03-02-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Add statements/Actions to an existing macro

    Have written my first macro, it’s really simple and just moves thing around a spreadsheet, but now I want to add some more actions to this existing macro. How can I do this?

    Many thanks,
    Glen
    Last edited by glenp99; 03-04-2010 at 07:23 AM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Add statements/Actions to an existing macro

    Hi glenp99

    what have you already recorded in macro One and what else do you want to do?

    Possibly just record another macro and cut and paste it in to the first macro
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    03-02-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Add statements/Actions to an existing macro

    Thanks for your prompt reply and cut/paste does sound a nice easy solution.

    So far I have just entered numbers in 20 cells and then added them up and coloured the answer red.

    I would now like to add another 4 or 5 columns and add each colume as weel and again colour them.

    I'm really new to this so am just practicing for now but for future use is there a way whereby you can create longer maybe more complex macros in stages ?

    Glen

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Add statements/Actions to an existing macro

    well you're in the right place if you get stuck and need a hand

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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