VBA Multiple Worksheet Change Events

Hi All,

Is anyone able to help me rework the below code so I can run these two macros (or More) within the same sheet. They are coflicting and a message saying an ambiguous name is detected appears.

Please Login or Register  to view this content.

Any help is appreciated.

Cheers

Adam

Hi Mudraker,

I am not very good with VBA! How would I combine such code to run off different cell changes?

Cheers

zimbo

I think mudraker has given you an idea on how to comnbine the code.

I think what you need to do is actually give us an idea, in words, what the code is actually meant to do.

Hi Norie,

In the example shown the first half of the code is for an in cell drop down which when selected will run one of three macros(only one shown). The second part of the code copies the formula's from the previous row in the sheet to the new line being entered (the excel auto formula copy isn't working even though it is selected - note my previous thread).

I also have another sheet in the same workbook with two cells needing to run seperate macro's on change.

Cheers

Adam

Hi Norie,

Is there any way a Worksheet change event can be written so that I can for example have cell A1 run Macro 1, cell A2 run Macro 2, range A3:B10 run macro 3, etc when each are altered?

Cheers

Adam

Thanks Mudraker,

That works perfectly.

Cheers

Adam

Originally Posted by mudraker

Please Login or Register  to view this content.

^ This really helped me out too, Mudraker. Thanks!