Thanks for the replies you all.
I tried your code Cheeky but get an compile error "Invalid use of Me keyword"

I did what you said. First defined the range and called it "FormatRange" but nothing...