Actually, that did the job, thanks! But what did you think was
wrong? It worked for 47k rows by 20 columns in a little under 5
minutes, probably not the most efficient, but it did work.

On Jun 1, 8:50 am, "Jim Cone" wrote:
Chris,

You need to use "Cells" instead of "Range".
Range is just not designed to function the way you are using it.
So...
test = ActiveSheet.Cells(r, c).Text

There appears to be other issues with your code.
We will probably here from you again. <g
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware