SOLVED: AutoFill Method of Range class failed - need help please!

[o4008]

I am trying to copy "B2" and have it autofill down to the last row - I keep on getting "AutoFill Method of Range class failed.

I've tried to declare LastCell, EndCell, RangeCells as String, as Long, as Range - but nothing works..

Please Login or Register  to view this content.

[mikerickson]

The destination range has to include the cell being filled down

Please Login or Register  to view this content.

[o4008]

I must be missing something because it is not working for me...

[o4008]

Did this instead - it works -

Please Login or Register  to view this content.

[davesexcel]

Another way

Please Login or Register  to view this content.

[o4008]

Thank you!