I have a range of cells; non-contiguous; namely

("D109, C111:K111, C114:K114")

What I would like to achieve is that when this range is complete with data
to have a macro run - lets call it "SetHR".

The range of cells is in a sheet called ("Current Round").

Now my thinking was to trigger the macro in the Worksheet_Change event - but
only trigger it when all cells in the range contain data (which is a mixture
of text and numeric), and the focus has now moved outwith the above range.
Furthermore not to run "SetHR" until any further change occurs to the above
range.

Hope this makes sense.

Any thoughts?

Sandy