Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a drop-down list from where the user can select which day he
wants to see. At first I hide everything, after that I run the little procedure below The problem that I'm having is that this takes lots of time running this. How do I change the procedure so it will run faster? Sub show_days() Dim compare Application.ScreenUpdating = False compare = Range("F10").Value Range("F13").Select For n = 1 To 8000 ActiveCell.Offset(1, 0).Select If ActiveCell.Value = compare Then ActiveCell.EntireRow.Hidden = False End If Next n Application.ScreenUpdating = True End Sub /Johan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Optimizing mortage payback | Excel Worksheet Functions | |||
MapPoint Optimizing | Excel Discussion (Misc queries) | |||
optimizing a macro | Excel Programming | |||
optimizing a lookup | Excel Programming | |||
Optimizing in VB | Excel Programming |