If I may suggest: record a macro that does what you need it to do,
then post the recorded macro. Indicate in the text of your email what
ranges you highlighted, and what ranges are likely to vary from use to
use.

Dave O
Eschew obfuscation