Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple text Status Bar which which shows the results of a search I
am doing through all the cells in a column (1 to 65536). I am using the Application.StatusBar = Range.Address. I effectiely show in the status bar what cell I am in while looping (A1, A2, A3 etc). As you can imagine the status bar updates frequently (every time I advance to a new cell in the column). I have noticed that the statusbar updates starts fast at first and then gradually slows down. It then crawls at a snails pace to reach 65536. I am Dimensioning my variable as a Double. Why does it start fast and then slow down over time as it approaches 65536. Can I dimension the variable differently or is this simply the reality of hava statusbar update that frequently? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updateing formulas | Excel Worksheet Functions | |||
What data type for Variable? | Excel Programming | |||
Trouble with variable type | Excel Programming | |||
type variable as argument of a sub | Excel Programming | |||
Variable Type - help me to solve this | Excel Programming |