Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill a Range
I have an Inputbox that asks for the number of couples attending an event.
If 50 is the value (stored in the variable NoCouples), and cell A1 already contains "Couple01", I would like cell A1 to be autofilled down as follows: Couple01 Couple02 Couple03 .. .. .. Couple50 Recording a macro that does this gives me the following line of code: Selection.Autofill Destination:=Range("A1:A50"), Type:=xlFillDefault How do I word my code to substitute NoCouples for A50? I've tried the following to no avail: Selection.Autofill Destination:=Range("A1:A + NoCouples"), Type:=xlFillDefault Thanks! Steve C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTOFILL with specific range | Excel Programming | |||
Variable Autofill range | Excel Programming | |||
autofill range | Excel Programming | |||
autofill with dynamic range | Excel Programming | |||
autofill with dynamic range again | Excel Programming |