Enhancements to Sub FillColBlanks by Dave Peterson
Dave, thanks. Tried your latest suggestion but it didn't work out, things
got messed up instead (although there's no more residual formulas anywhere).
Pre-run example (all numbers indicated are text numbers)
88
< I selected this cell, then ran the sub
89
090
Total
Result:
88
88
89
88
88
88
090
88
88
88
Total
But when I revert to using the sub in your 1st response, I got:
88
88
89
89
89
89
090
090
090
090
Total
which is more what I want (ie retention of original text numbers in the fill
down), albeit there are residual formulas. The only cell that got converted
to real number was the single cell I selected when I run the sub. I would
just reinstate this single cell to a text number.
Rgds
Max
|