So, how can we help. You really need to help us to help you.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"scone57" wrote in message
...
I am not sure of the range as it will change monthly, so cant set it,but at
the moment the column states FALSE, when there is no data in the previous
columns.

"Don Guillett" wrote:

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?