E
ExcelMonkey
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
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