Shg,

It beeped. I moved the reference from AC1 to V1 and it worked! Praise VBAllah.

However, I have no idea why the variable needed to be in the same set of columns as the selection range.

Anyway, thank you very much. My excel project has taken a giant step forward.