hip2b2
Board Regular
- Joined
- May 5, 2003
- Messages
- 135
- Office Version
- 2019
- Platform
- Windows
I am using the following code to delete rows in the ABC sheet where the citeria is currently X.
I need the code to be modified to allow multiple variables (X, Y or Z)
As always any help is appreciated
regards
hip
I need the code to be modified to allow multiple variables (X, Y or Z)
VBA Code:
Set h = Sheets("ABC")
'If h.AutoFilterMode Then h.AutoFilterMode = False
'u = h.Range("K" & Rows.Count).End(xlUp).Row
'h.Range("A6:K200" & u).AutoFilter Field:=11, Criteria1:="X"
'Rows("7:" & u).Delete Shift:=xlUp
'If h.AutoFilterMode Then h.AutoFilterMode = False
As always any help is appreciated
regards
hip
Last edited by a moderator: