Auto fill error

[Maggielove]

Please could someone tell me why the Autofill destination does not work with single rows?
i am using
Range(“h2”).Autofill Destination:=Range(“H2:H” & last row)
It works perfectly for multiple rows, but gives me an Autofill method of range class error if there’s only one row of data.

 

[Fluff]

You can't autofill one row as there is nothing to fill
You can test if LastRow =2 & if it does skip the autofill line

 

[Maggielove]

Many thanks Fluff. Sounds obvious now you say it!

 

[Fluff]

You're welcome & thanks for the feedback.
Unfortunately the "obvious" very rarely is.