I have a large spreadsheet, with alot of VB data validation (under a
Worksheet_SelectionChange sub) and hiding/unhiding of rows (under a
Worksheet_Change sub) based upon user input. Whenever a cell entry is made,
the screen flickers alot, as if it is going through too much code - it is not
a smooth (or quick) transition from one cell to another. The code module
for this worksheet is 55KB; I have read that you shouldn't get over 64KB.
Could the size of the module be the problem? I've put in
Application.ScreenUpdating = False, but that doesn't help, and tried using
alot of target.address stuff in the Worksheet_Change sub...but still have the
problem. If I remove the Worksheet_Change sub most of the problem goes
away....however, I need the functionality provided so that is not a
resolution. Would appreciate any thoughts/guidance on what I may be doing
wrong or how I could improve this. Thanks so much....