Thanks I will try it.

How about taking it one step further?

Naming that range? I want to use the
name "test" that was defined earlier,
but after deleting it and redefining it,
the recorder put those referrs to: actual
locations in there. or even better define
ranges within. First 13 entires(rows) = test1
next 13 test2, etc with the last one being
a partial list.

-Randy-





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!