View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cate cate is offline
external usenet poster
 
Posts: 93
Default record sheet row order, then restore to that point

There is the ability to undo a sort so I suspect the information I
want is somewhere. Is there a way to take a "snap shot" of a sheet's
current row order, and then restore that row order at any point in the
future? During sheet processing, rows will not be added, but data in
any cell may change.

The only other way I can think of doing this, is to record the order
of some "signature" column and then use it to re-write the processed
sheet to a scratch sheet.

Thank you