Hi I am using the code below to autofill but for some reason it doesn't autofill the whole column to last row on some pages?
<code>lngLastRow= ActiveSheet.UsedRange.Rows.Count
Selection.AutoFill Destination:=Range("C2:C" & lnglastrow)
Please advise.
Thanks.</code>
<code>lngLastRow= ActiveSheet.UsedRange.Rows.Count
Selection.AutoFill Destination:=Range("C2:C" & lnglastrow)
Please advise.
Thanks.</code>