View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Align cells with same value - vba almost working

Errata....

On Mar 12, 8:57*pm, joeu2004 wrote:
If that assumption is incorrect, it is easy to add the Insert
Shift:=xlDown. *But in that case, it would better to change
the implementation fill the aligned data into local arrays
first and to make other prudent design changes.


Actually, I already made the change to use local arrays; more
efficient anyway. The needed adjustment is the appropriate Insert
Shift:=xlDown operations.

Let me know if you want that.