View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Variable Type and Speed in Updateing Status Bar

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