Tell us more. Do you want to set the range or just the last row of this
range.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"scone57" wrote in message
...
Having trouble changing a fixed range to a variable range in VBA.
When creating the macro, I used a fixed range, but now need to change this
to a variable, for future spreadsheets.

Range("R4").Select
Selection.AutoFill Destination:=Range("R4:R886")
Range("R4:R886").Select

Can anyone help?