Folks,
My code snippet is attached below. Notes follow.
I am working on a range of less than 50 rows on a single worksheet. I have screenupdating turned off. Even so, this macro seems to take forever (in computer time). This is the only thing the macro is doing, so I think I may be using a poor choice of syntax. Any help would be appreciated. Thanks in advance.
Conor.
For Each rw In Worksheets("User Dialog").Range("OrderQuantities").Rows
If rw.Cells(1, 1) = "" Then
rw.Hidden = True
End If
Next
FYI - OrderQuantities is a named range one column x 45 rows
Bookmarks