autofill not working

[stubyh]

Hi

I'm trying to autofill down on column L to BM. The lastrow is unknow and only needs to fill the next row down. the code I have so far is below but it errors on the last line. Thanks in advance.

Please Login or Register  to view this content.

[RHCPgergo]

Hey,

I think fillRange should include SourceRange, so the Set fillRange line should be:

Please Login or Register  to view this content.

[TMS]

Try this:

Please Login or Register  to view this content.

Regards, TMS

[Norie]

Perhaps this.

Please Login or Register  to view this content.

[stubyh]

hi

thanks all used Norie solution in the end.

[Naja]

Hello,

Can you please attach the workook with the working vba? It will be very helpful.

Thank you

[Norie]

Naja

If you have your own question start a new thread.

PS There's not really a workbook involved in this thread.