#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default about screenupdating

Hello,
I have a long code which is a kind of poker simulation that gives you
simple random poker hand and calculates the odds.If I disable
screenupdate some of the values are gone missing.It does not count
properly.However, if I activate screenupdate, no values are gone
missing. I am talking about 1 million live game or so which takes 20
minutes to run the code all in all. Is that possible that if you
'screenupdate=false' some of the data is gone missing.just for a
reference here is a part of my code
If Sheet1.Range("E12") = 5 Then
e = e + 1
Sheet1.Range("F12") = e 'that is when there is a flush
End If

any idea?
Thanks
Have a good day
Baha
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
Why does Selection.PasteSpecial toggle Application.ScreenUpdating OssieMac Excel Worksheet Functions 2 August 4th 09 12:05 AM
How to set Application.ScreenUpdating = False for Gen use David_Williams_PG () Excel Discussion (Misc queries) 1 August 15th 06 12:06 PM
Screenupdating Problems Trent Excel Discussion (Misc queries) 0 April 28th 06 07:03 AM
What does ScreenUpdating = False do? Judy Ward Excel Worksheet Functions 5 July 9th 05 09:25 AM
Application.ScreenUpdating function question Fleone Excel Worksheet Functions 2 May 12th 05 01:36 AM


All times are GMT +1. The time now is 01:13 PM.

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

About Us

"It's about Microsoft Excel"