Anyone care to take a look at this. The OP wants what it says on the tin, to combine 3 VBA functions.

Combining 3 VBA functions into a single VBA sub

I don't have time to unravel it and wondered if anyone else was up to the challenge.

Thanks.