Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I've created a spreadsheet with a plan-board. The plan-board is filled from a sql server-based planning system. The planboard has two outline levels. There are ± 300 row groups. At the end of the code for refreshing the plan-board is this line of code: objWS.Outline.ShowLevels rowlevels:=1 Executing this codeline takes 4 seconds. Is there a way to make this faster? Thanks, Jan Vente The Netherlands |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
outline | Excel Worksheet Functions | |||
Outline.ShowLevels | Excel Programming | |||
Outline.ShowLevels | Excel Programming | |||
Outline.ShowLevels | Excel Programming |