sorting in a shared wkbk

K

ken smith

XL2000 SR-1 on Win2K SP3. Strange behaviour sorting a list
from the menu or via code in a shared wkbk. Standard
rectangular list with headers (say A1:D50) without empty
rows/cols. Unshared wkbk = everything normal. Shared wkbk
= try sorting from the data menu, xl selects A2:IV50. With
activecell A1 - Edit/Goto/Special/Currentregion works
normally. Code to sort Range("A1").Currentregion... sorts
A2:IV50, headers recognized.

Also - any way to toggle sharing via code to update pivot
tables, sort (given above problem), etc?

Any ideas? Thanks,
Ken Smith
 

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

Strange Sorting in a Shared Wkbk 1
Range object causing Sort to fail 2
Sorting issue has got me puzzled! 0
Sorting issue has got me puzzled! 1
Preserving cell validation on worksheets post data merging 1
Open Another File to Search and Replace Text 1
Sorting in Ascending Order 2
odd sort issue with numbers 2

Top