View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Michael[_3_] Michael[_3_] is offline
external usenet poster
 
Posts: 5
Default Selection.Sort problem with formulas

Yes! What I really need is a way to Cut a range (of rows) from the
Worksheet, moving the rows below the cut region up to close the gap, then
Paste those rows to the head of the Worksheet, pushing down the existing
rows (rather than overwriting them, as it does when I manually cut and
paste)!

This would preserve the Range Name definitions, from what I can tell, and
re-order the sections without screwing up stuff below the colored sections.
Any thoughts?

I believe I can code the routine to recursively go thru the entire range of
cells looking for the lowest sort number (by hundreds) and selecting up to
the next colored section ok.... now if I can just cut the selected section
out (pulling what's under it up, to close the gap). How to do that?

- Michael