Range.Text should be able to return an array of results like Range.Value
Range.Text should be able to return an array of results instead of only being able to return the text for a single cell. Its behavior should be consistent with Range.Value and Range.Value2.
Additionally, Range.Text should never return a result like '#####' when the column width of the cell is too small. It should always return the text that would be visible if the column was wide enough (and calling Range.Columns.AutoFit before calling Range.Text should not be necessary).
Charles Williams commented
Surely a simpler solutiin is NOT to use .text in the furst place?
This is great idea! Several of my projects would be much faster and stable.