Autofill:double clicking on the lower left hand corner

[duration]

Hello,

How do call this action of creating a formula in a cell, selecting the cell where the formula is in, and then double clicking on the lower left hand corner so that is fills all the cells below until there is no more data on the left hand side column?

(See attached screenshot).

And how does this operation translated in a VBA macro for Excel?

I use Excel 2010.

Thank you in advance for your help,

[davesexcel]

Try this

Please Login or Register  to view this content.

[duration]

Try this

Please Login or Register  to view this content.

Hi Dave,

Thank you for your reply.

It sort of does it, however the "Rows.Count" counts all the rows, including the blank ones..

How do I set it so that it only counts non-blank cells?

Many thanks,

[davesexcel]

Your example does not show any blank cells,
this amended code will count the rows in column B instead of counting the cells in the entire worksheet.

Please Login or Register  to view this content.

[duration]

Dear Dave,

It works, thank you very much for your help!

Take care,