In this particular one, the word "Selection" in "Set rAllRange =
Selection" (beginning of code) is highlighted and the error reads
"Compile error: Type Mismatch"

Any help would be greatly appreciated. I am truly stumped on this one.

Hi,

You should specify the Selection address first,
before running code related selection ...
Perhaps you selection is empty or nothing, so Error raised

Tks
Halim