Hi

I've managed to run a worksheet change macro by calling it via my code
(ie run Worksheet_Change), but it takes ages to execute. Is there a
more efficient way of doing this?

I'm really sorry if this is all very basic stuff for you guys out
there, but I am very new to VBA and try and dip my toe in the water and
am looking at getting some formal training.

Cheers!


DeeCee wrote:
Thanks Jim

I am really new to all this and I generally Google to find code and
then try and fit it to my requirements from there.

I've put your suggested amendment in and it does work for all the range
in "weekcal", but I still have to go into one cell and hit return. Is
there a way of having this done automatically as soon as the validation
list changes?

Many thanks.


Diane