Can a filtered list (VisibleCellsOnly) be sorted?

E

EagleOne

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
 
S

Sandy Mann

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
E

EagleOne

Sandy,

I did try, and got a "multiple segment (or selection)" error. I'll make a few more attempts.

Thanks EagleOne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dropdown list and filtered data 8
Report cell from Filtered lists with text 1
Copy data in filtered list 3
Pasting into a filtered list 2
VBA code to Fill Down in a filtered list only to visible cells. 1
Excel 2007 - Problem Copying and Pasting From An Auto-Filtered List 2
extract items from filtered list 1
Dim an array from a filtered Range 1

Top