View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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