Dynamic Auto Fill as part of a Macro

[JacobStone]

I am trying to compile a macro which prepares a series of reports.
Part of this is to select cell A2 and then double click the autofill handle, when it will then copy it down to the end (column B contains data, column A is empty, but excel knows when I double click the autofill handle in Cell A2 to stop at the cell adjacent to the last row of data in column B)
When I record this action in the macro, it places a range, which is relevant to this set of data only (A2:A9565), as the number of rows of data will change each time I prepare this sheet.
Can anyone help me so that the macro carries out the same action as if I were to simply double click the autofill handle.
Your help is very much appreciated.

[Domski]

Hi,

Maybe something like this:

Please Login or Register  to view this content.

Dom

[JacobStone]

Hi,

Maybe something like this:

Please Login or Register  to view this content.

Dom

Works perfectly, thank you so much, your resolution is far more useable than the one from my IT support, ;-)

Thank you again.

Jacob

[Sombradeti]

I had this same problem, but I was wondering if you can take this one step further and have the macro automatically extend the formula down as you add new data?

[Domski]

Hi,

That's a quite different issue but quite possible. Per the rules I suggest you start a new thread referencing this one if you think it's relevant.

Dom