Automation Macro...

hurricane · #1 (**permalink**) 08-06-04, 16:37

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

shades · #2 (**permalink**) 08-06-04, 17:37

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.

hurricane · #3 (**permalink**) 08-09-04, 13:06

shades,

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

hurricane

Internet Services

Web Development

Digital Marketing

Consumer Tech