What's the quickest, most efficient way to do something to every cell in a
range? I've got a range of cells, and I want to do one of the following
depending on user params:

1) replace every value with an apostrophe and the value (coercing it to a
text data type for Access import)
2) replace every value with the Val() of that value (replacing blank cells
with 0, again for Access import)

I'm conversant with the "For Each C In objR.Cells" loop, but I've got
20,000+ rows and this loop is taking too long.

Any other suggestions that would accomplish the same thing would be greatly
apperciated.
--
Hmm...they have the Internet on COMPUTERS now!