Put it in a worksheet cell

For i = 1 To 10000
ActiveSheet.Range("A1").Value = i
'do your stuff
Next i

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"simoncohen " wrote in message
...
I would like some code to put in a macro to give me an on screen counter
of the number of times a particular loop has been processed. MsgBox
type functions appear no good as enter needs to be hit each time. Any
Ideas ? Thanks


---
Message posted from http://www.ExcelForum.com/