I have the following macro, which is doing what I want it to do:
Sub ScheduleHideRows()
Application.ScreenUpdating = False
Dim rws As Range
For Each rws In ActiveSheet.UsedRange
If rws.Value = JP1 Then rws.EntireRow.Hidden = True
If rws.Value = JP2 Then rws.EntireRow.Hidden = True
If rws.Value = CDay Then rws.EntireRow.Hidden = True
If rws.Value = RR Then rws.EntireRow.Hidden = True
Next rws
End Sub

Is there a better way?
Here is the scenario:
I run several different reports from the same database.
Each report contains many of the same columns, but each report displays the
columns in a different order.
For some of the reports, I need to hide records that match certain criteria.
The criteria have been defined with public constants.
Is it possible to make an intelligent filter macro that will adjust to the
different column orders?
Thanks,

--
tj