What I mean is I can't see anyone wanting to use a function
on the workbook to return the value of a cell large enough to
include an entire sentence. I would think someone would only
want to use a macro and change the values of the selected
cells in place.

A function only returns a value. The point is I can't see using
a function like that within the worksheet. It usually means
copying the result, pasting back as values and then deleting
the original column -- waste of time.

If you want I can email you my test.
---

"Peter T" <peter_t@discussions wrote in message
Afraid I don't follow, as I understand it the function and your sub only
convert existing cells. Possibly I've missed something from earlier in the
thread.