autofill macro

[max8719]

Hi,

For some reason the autofill is not completing all rows of the data ranges.

I am using a work book and the range of rows can change once the report is generated and the rows can vary per sheet.

I am using the code:

lngLastRow= ActiveSheet.UsedRange.Rows.Count
Selection.AutoFill Destination:=Range("C2:C" & lnglastrow)

Any advice is much appreciated

 

[MARK858]

Is this not the same question as you have asked here?

What is different that isn't answered in post #3?

 

[ukmikeb]

Or try :-

lngLastRow = Split(ActiveSheet.UsedRange.Address, "$")(4) + 0

Also answered in the thread @Mark858 refers to.

hth

 

[max8719]

Thanks