After serious thinking Ron Rosenfeld wrote :
On Thu, 30 Dec 2010 16:52:21 -0500, GS wrote:

but what's
with declaring/setting rg and not using it?

Uh, user error.

I usually set rg to the range to process, and then cycle through it.

I rarely use "Selection" but, absent other information, I did in this case.

Usually I'll do something like:

set rg = range("A2", cells(cells.rows.count,"A").end(xlup))

to pick up all the active cells in column A.

Ha, ha! It sounds like you've had a long day! I suspected your
intentions but was thrown off by your use of Selection. Looked out of
place for you.<g

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc