A AlexD May 21, 2004 #1 How could I refresh or repaint a worksheet. I couldn't find anything from VB by using Me. ... . Thanks
How could I refresh or repaint a worksheet. I couldn't find anything from VB by using Me. ... . Thanks
C Chip Pearson May 21, 2004 #2 Alex, If ScreenUpdating is false, set it to true. E.g., Application.ScreenUpdating = True Or, are you talking about repainting a userform? Me.Repaint -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Alex, If ScreenUpdating is false, set it to true. E.g., Application.ScreenUpdating = True Or, are you talking about repainting a userform? Me.Repaint -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com