Hi,
I have created code to filter data in column E for specific criteria. Now I want to use a formula in column I for only those rows that are visible. The number of rows will change each week. Below is the code I have thus far. Thank you in advance for any help. I am still learning VBA a little at a time.
Sub VBAcodeFilter()
'
' VBAcodeFilter Macro
'
'
Range("A1:M1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$M$200").AutoFilter Field:=5, Criteria1:= _
"=OnCall-Pay", Operator:=xlOr, Criteria2:="=OT-Pay"
Dim LR As Long
LR = Range("E" & Rows.Count).End(xlUp).Row
Range("E2:M" & LR).SpecialCells(xlCellTypeVisible).Select
End Sub
Bookmarks