Think you just want to set calculation to Manual (in tools => options,
calculation tab) when you are entering data. Or use a macro to turn off
events.

Sub EventsOff()
Application.EnableEvents = False
End Sub

Sub EventsON()
Application.EnableEvents = True
End Sub

--
Regards,
Tom Ogilvy


"mav93" <[email protected]> wrote in
message news:[email protected]...
>
> thanks Tom the code worked great
> I know that this maybe asking a lot but anytime that I enter a value
> into any cell throughout my whole enitre workbook even ones not related
> to the code and not in the same worksheet, my screen glitches and after
> entering 250 rows of information the screen starts to look like a
> strobe light.
> Trust me I am extemely thankful for the fix you gave me I'm just
> wondering if this glitch could be fixed as well.
>
> Thanks for your time.
>
>
> --
> mav93
> ------------------------------------------------------------------------
> mav93's Profile:
http://www.excelforum.com/member.php...o&userid=31592
> View this thread: http://www.excelforum.com/showthread...hreadid=512860
>