Ok Duke - thanks so much! Your script worked fine, however it stops
with a run-time error '1004' after just processing 895 rows of a
30042-row spreadsheet. It works beautifully up to that point,
transposing nicely. When I click on "debug", it points to the
Cells(intRow, intCol).Value = rng.Text line.

Any ideas at what is breaking it?
Scott