+ Reply to Thread
Results 1 to 2 of 2

copy macro

  1. #1
    Registered User
    Join Date
    07-10-2007
    Posts
    31

    copy macro

    I have a macro in c1 which fills in data on range c3:c20 which I assign to a button

    My issue is I want the same macro in d1 which fills in data on range d3:d20 and so on.
    How can i copy the button macro in c1 to d1 which with copy data in d3:d20.

    I dont want to keep creating macros

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: copy macro

    i dont think youve got a choice but to do that!
    but you could make life easier by setting up a template in excel to generate the code then copy paste it into vba editor
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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