Can any MVP take this up and help me??

[CAPTGNVR]

Dear MVPs n Others
( I am reposting as got no response)
I have made one consolidated program for the crew onbd and the zipped file
will be around 400kb.

AA) I want to send it as email, so that I can get some guidance as to 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" as,
it 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 mvp/programming 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.