Message when cell changes

Try changing this line:

Set myRange = Range(sGblSheet1RANGE)

to this:

Set myRange = Union(Range("A6"), Range("A9"), Range("A12"), Range("A15"), Range("A18"), Range("A21"), Range("A24"))

Originally Posted by stnkynts

Try changing this line:

Set myRange = Range(sGblSheet1RANGE)

to this:

Set myRange = Union(Range("A6"), Range("A9"), Range("A12"), Range("A15"), Range("A18"), Range("A21"), Range("A24"))

Not sure if I changed the correct part, or not, but it didn't seem to work. I've sent a pm with a link to the spreadsheet I'm using and more details if that will help