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











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks