...I'd like the page to scroll down, along with each new Prime.
Are you referring to this kb article?
http://support.microsoft.com/kb/202782/en-us
This is not the best, but something quick n dirty:
Change:
ActiveCell.Offset(Count, 0).Value = y
To:
If Count 10 Then _
Application.Goto Cells(Count - 10, 1), True
Cells(Count, 1).Value = y
and change to this at the beginning:
Count = 1
Again, this is not the best, but it may give you some ideas.
--
HTH :)
Dana DeLouis
Windows XP & Office 2003
"George C." wrote in message
...
On Fri, 22 Dec 2006 15:29:28 -0600, "John Bundy"
wrote:
Had to build a couple back in school, how large of a number are you
needing?
Hi. I found one on the Microsoft site, after extensive searching
around.
It starts with two dialogue boxes for first integer and final integer.
It's MUCH more simpler than the concoction I had in mind.
BUT I still have a question.
I generates the primes, and goes down column A as it posts each prime
found. But, I'd like the page to scroll down, along with each new
prime that is entered.
I found this command, but cant get it to work:
ScrollActionLineDown(0,1)
Please advise.
Thanks, once again
--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"Hrundi V. Bakshi" wrote in message
.. .
Hi, I appreciate everyone trying to help.
If left to me to program, it simply won't happen..
So could someone please point me to a prime number calculator written
for Excel VBA ? That's all I'm looking for (at this time).
Thanks,
Hrundi