Status Bar = Format(fraction Done, "0%") & "done..." ' or, alternatively: ' status Range.value = Format(fraction Done, "0%") & "done..." ' Some code.......

Next i Sub Progress Meter() Dim boo Status Bar State As Boolean Dim i Max As Integer Dim i As Integer i Max = 10000 Application.

Status Bar = False ''//Return control of the Status bar to Excel Application.

This sometimes causes Excel’s application window to become totally unresponsive.

The way out of this frozen state is simple: Go back to the VBE, and execute the following statement in the Immediate window: If you have a worksheet with many complex formulas, you may find that you can speed things considerably by setting the calculation mode to manual while your macro is executing.

Dictionaryif BNVi[j Azz̎gɂ‚Dictionaryif BNVi[j̃pt H[}Xɂ‚VBAłInternet Explorer VBAłSQL̊bi SQL: Structured Query Languagej VBAŐK\𗘗pi Reg Expj VBAŃ[Mi CDO: Microsoft Collaboration Data Objectsj VBAłOutlook Vlookup VBAōɏ@ɂ‚āb Excel}NVBAZpi1212j IZȂ}NVBAwڂb Excel}NVBATv Wi1126j Screen Updating=FalseɃG[~ɃV[gł܂b Excel}NVBAZpi1121jf[^NWOƖ񂹁b Excel}NVBAZpi1020j SUMIF̊ԈႢɂpt H[}X̒ቺɂ‚āb GNZ֐Zi617ĵ낢ȏFTrue False̔Ƃ́b Excel}NVBAZpi615j󔒃Z𐳂肷@2b Excel}NVBAZpi56jtp Xf BNg [email protected]ɕb Excel}NVBAZpi415je LXg NVBATv Wi44j 1.ŏIs̎擾i End, Rows. Range Cells̎gb Excel}NVBA3.ϐƃf[^^i Dimjb Excel}NVBA4.

Z̃Rs[&l̓\ti Paste Specialjb Excel}NVBA6.萔ƌ^錾i Constjb Excel}NVBA7.}NĉHVBAĉHb Excel}NVBA8.

Excel executes the default operation for these types of messages.

In the case of deleting a sheet, the default operation is Delete.

Display Status Bar = True ''//Make sure that the statusbar is visible For i = 1 To i Max ''// imax is usually 30 or so fraction Done = CDbl(i) / CDbl(i Max) Application.

Status Bar = Format(fraction Done, "0%") & " done..." ''// or, alternatively: ''// status Range.value = Format(fraction Done, "0%") & " done..." ''// Some code....... Display Status Bar = boo Status Bar State ''//Reset Status bar display setting Application.

It's just an idea for you to try, and its effectiveness is pretty dependent on your sheet and calculations.