Macro to extend range

[mbrandt5]

Please Login or Register  to view this content.

Would someone be willing to assist me in making the range in this code a variable that starts at (A2, A10) then goes adds ten to the end of the range whenever a different macro is executed?

Lets say that different macro is called Macro X

So when Macro X is executed, the range in this private sub will add ten and become (A2, A20)....

If ran again it will be (A2, A30) (A2, A40)...etc.

[PCI]

A suggestion could be
in ThisWorkbook

Please Login or Register  to view this content.

in a module

Please Login or Register  to view this content.

Then each macro call once UpdataRg as Test() is doing

[mbrandt5]

Two things I'm stuck on the option explicit before it creates a line between the two...
Also do I just replace the UpdataRg with the name of the Macro that triggers the update?

[PCI]

"option explicit" is just to ask VBA to check that all variables have been define with the Dim statement
"the Macro that triggers the update" is "Sub Test()", it means inside your macro put

Please Login or Register  to view this content.