View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default Can a filtered list (VisibleCellsOnly) be sorted?

Heve you tried it? It works for me in XL97 on a simple test.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


wrote in message
...
2003

Would like to sort visible cells only in a filtered w/s.

Common sense tells me no.

I realize that I could copy the filtered data to a separate sheet and then
sort.

That said, I would the information on NewSheet to replace the respective
information
from the original filtered sheet.

What logic/knowledge am I missing?

Any help appreciated!

EagleOne