I'll look at your post.

FYI, can you check the cell ref syntax in post #1? I corrected those, your post #5 reintroduces the incorrect syntax. If you don't mine fixing those, I'd appreciate it. The : is used in Excel to indicate a connection of beginning range and ending range. A cell reference doesn't use those.

A22
B22

A22:Z22 < a range
A:A < all cells in column A
1:4 < all cells in rows 1 thru 4

Thanks.