Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Showing Loop Status

Gil,

You could try

Range("A1").Value = "Now on iteration " & Format(c,"#,##0")

or you could put it in the statusbar

Application.StatusBar = "Now on iteration " & Format(c, "#,##0")

--

HTH

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

"Gil" wrote in message
...
Is there any way to display in the spreadsheet how many times a *Do Until*
procedure is looping?
I'm thinking of something simple in the loop like *c=c+1* (??) but how do

I
get to show the *c* value in , say, cell A1 .

Many Thanks




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Status Bar not showing statistics Victoria612 Excel Discussion (Misc queries) 2 January 6th 10 03:51 PM
reuest formula for auto update status & status date PERANISH Excel Worksheet Functions 5 June 2nd 08 04:26 PM
Why is calculate showing in status bar at bottom of spreadsheet? Sean Grier Excel Discussion (Misc queries) 3 May 5th 05 10:33 PM
Status Bar Every Nth Loop ExcelMonkey[_9_] Excel Programming 3 January 21st 04 09:52 PM
HELP!!!! Can't stop a loop (NOT an infinite loop) TBA[_2_] Excel Programming 3 December 14th 03 03:33 PM


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"