EXCEL 97: Can anyone check slow execution??
 

DEAR ALL
I have made one consolidated program for the crew onbd and the zipped file
will be around 400kb.
AA) I want to send it to the specialists who can see why when I click the
procedure to place a serial number 1 to 45, it takes enormous amount of time
and also the computer makes high revving sound and comes down ones the
serial numbers are put.

BB) Secondly, want to know why I am unable to see the edit-fill "series" is
not higlighted and accesible.

CC) It took me a while to figure out that this unable to see
edit-fill-"series" could be the reason for getting error in VB, when I use
the filldown to fill serial number. Hence I wrote a procedure using for
next and fill the numbers but the delay in performing this is uncalled for.

So will any of the Gurus clear my long pending quest to find out the reason
for this happening?? If yes give me ur email id and I will send the file. I
(my company) use excel-97.

Pls come forward n thnks.

EXCEL 97: Can anyone check slow execution??
 

Oh No. Till now no response and soon this post will not be seen. Pls can
some MVP devote some time for my long pending quest. Only in this forum I
have hopes of getting this sorted out.
with hopes
captgnvr

"CAPTGNVR" wrote:

DEAR ALL
I have made one consolidated program for the crew onbd and the zipped file
will be around 400kb.
AA) I want to send it to the specialists who can see why when I click the
procedure to place a serial number 1 to 45, it takes enormous amount of time
and also the computer makes high revving sound and comes down ones the
serial numbers are put.

BB) Secondly, want to know why I am unable to see the edit-fill "series" is
not higlighted and accesible.

CC) It took me a while to figure out that this unable to see
edit-fill-"series" could be the reason for getting error in VB, when I use
the filldown to fill serial number. Hence I wrote a procedure using for
next and fill the numbers but the delay in performing this is uncalled for.

So will any of the Gurus clear my long pending quest to find out the reason
for this happening?? If yes give me ur email id and I will send the file. I
(my company) use excel-97.

Pls come forward n thnks.