Run time error '1004' Autofill method of Range class failed

Hi,

I have gone through numerous threads and are new to vb, but can't find a solution for the following error, assistance will really be appreciated.

I found the following code on your forum, but get the following error :

Run time error '1004'. Autofill method of Range class failed.

The error occurs when the spreadsheet either have 1 row of data completed or no data, can I get code to ignore the autofill when I only have 1 row or no rows completed in various spreadsheets. I have attached a copy of the spreadsheet.

Please Login or Register  to view this content.

Thank you so much for viewing this for me ;-)

You could try this,

Please Login or Register  to view this content.