Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting in a shared wkbk
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting in a shared workbook | Excel Discussion (Misc queries) | |||
Sorting Shared Workbook | Excel Discussion (Misc queries) | |||
Sorting in Shared Workbook | Excel Worksheet Functions | |||
sorting in a shared wookbook | Excel Discussion (Misc queries) | |||
Sorting in a shared workbook | Excel Discussion (Misc queries) |