I need to make a macro run whenever cell F4 (strictly speaking the merged
cells F4:F6) on the current worksheet is edited. I'm sure this must be
possible but can't find anything in the help files or online to tell me how...

Any ideas?

Thanks

Phil