StatusBar Msg?
Yep - thanks - typo.
Application.StatusBar = False
--
Regards,
Tom Ogilvy
"JON-JON" wrote in message
...
Pardon me if I am wrong. Application.StatusBar = False to return the
control of status bar to xl.
"Tom Ogilvy" wrote in message
...
Dim i as long, numrows as Long
numRows = 10000
for i = 1 to numrows
' code to process row
if i mod 100 = 0 then
Application.StatusBar = i & " rows processed"
end if
Next
Application.StatusBar = True
--
Regards,
Tom Ogilvy
"M." wrote in message
...
I'd like to show (like progres bar show ) msg in status bar how many
rows
was procesed!
I need some suggestion!
Milos
|