I want to fill a range. I have a formula in J2 and I want to fill i
down to J10 (8 rows). When I record it, it looks like the code below.
However I want the number of rows to fill to be variable. How do
pass a row variable to this?

Sub Macro8()
Sheets("Paste Range").Select
Range("J2").Select
Selection.AutoFill Destination:=Range("J2:J10")
Type:=xlFillDefault

Range("J2:J10").Select
End Sub

Thank

--
Message posted from http://www.ExcelForum.com