Thread: Slow Code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shawn Shawn is offline
external usenet poster
 
Posts: 271
Default Slow Code

I need a suggestion. Employees send their timesheets via email into our
central office. We have an Employee Database created in excel. A VBA copies
and pastes the time sheet information into the Employee Database and stores
it.

There is a hidden sheet in the Employee Database that the copied information
from the Time Sheets gets copied into. I have noticed when I try to unhide
this sheet, it unhides extremely slowly. Why? Is there ghost information
being stored in this sheet that is making it large? Suggestion solution?



--
Thanks
Shawn