Hello, I'm trying to create a macro that:
1. asks the user to input a number of sets
2. uses that that number to autofill the correct amount of rows
This is kind of the idea:
Dim Reply As Integer
'Ask how many exposed sets
Reply = InputBox("How many exposed sets?")
'Autofill from the current position
ActiveCell.Offset(-2, -8).Range("A1:I2").Select
ActiveCell.Offset(1, 8).Range("A1").Activate
Selection.AutoFill Destination:=ActiveCell.Offset(-1, -8).Range("A1:I[(Reply)*2+2]"), _
Type:=xlFillDefault
ActiveCell.Offset(-1, -8).Range("A1:I6").Select
Thanks for any insight!
Bookmarks