Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Smile Unanswered: Automation Macro...

    Not to be redundantly redundant, but could I get someone's thoughts on a macro to do the following?

    (1) Input Box asks for a specified range to copy, say a1:d10
    (2) Input Box asks for a starting destination, say a11
    (3) Input Box asks for the number of times the range inputted from (1) is to be copied, say 3 times
    (4) Result: Range a1:d10 is copied (formulas and relative references changing as each copy of the range is made) to:
    a11:d20
    a21:d30

    Please Help!! Many, many thanks in advance....

    Hurricane

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    As a starting point consider this approach:

    Code:
        Dim myRng As Range
        Dim DestRng As Range
        Set myRng = Application.InputBox("Select Range", Type:=8)
        Set DestRng = Application.InputBox("Select Destination Range", Type:=8)
    This allows you to select the range and destination. Of course, then you will have to copy and paste. Change to suit.
    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
    Aug 2004
    Posts
    2
    shades,

    thanks for the feedback. i will build out from here and post back my finished macro.

    hurricane

Posting Permissions

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