It sounds like it's working <vbg.

Dennis wrote:

You are correct that many of the cells in the computed range evaluate to "".
The cells that I wanted were those which did not = "". I was not clear
enough.

I had a Pivot Table which, depending upon the Autofilter choices, displayed
information in a table of varying length.
The quick but dirty first solution was to copy down formulas in cols F & G
20,000 down to display in columns to the right of the Pivot-table itself.
(The longest table display was 18,000+)

Later I wanted to automate it in VBA plus I was copying far too many cells
without meaninful data. Thus I wanted a way to limit the "To Copy" range
since the data stopped usually far less than 20,000 cells down.

Your information was crutial structure and method.

What I should have told you was that in Col E was either subtotals or dollar
info. That is why I attempted the IsNumeric but settled on the Len() 0.

BTW, your aditional information is extremely interesting as it causes me to
want to experiment. This stuff will never sink in for me if I do not value
what is happening behind the "screen."

Thanks!



<<snipped
--

Dave Peterson