Extending the Range of 'Target.Address'

[Mhz]

Hi,
I would like to extend the Target.Address selection to be selected from
B7:B35. The previous command I had listed as follow:

Is it possible to extend the range beyond one cell selection? I would like
for any cell within the B7:B35 range to carry out the same function /command.

Thanks for any help on this...

[antoka05]

You may try with this macro:

Please Login or Register  to view this content.

Regards,
Antonio

[Mhz]

Thanks antoka05,

I got your solution to work. Now Im having a problem with the
Application.EnableEvents = True and Application.EnableEvents = False.

The Active Worksheet I'm Using Keep Triggering Itself when I activate it.

This Is the Worksheet Code I'm Using:

Thanks..