Hi snb!

This works well in the supplied excel file. I (somewhat) succeeded in adapting the code to a bigger range of data.

But if I change some cells (H6, G3 - should not be formatted) the macro doesn't get it. Do you have an idea why this might occur?

HazardLog-dummysheet_snb.xlsm

Thank you for your time & have a nice weekend
Greetz