I would like to write an if statement, but I don't know the proper way to write it. Basically, it's just
If R3 = 1 Then
ActiveSheet.Range("$R$3:$AA$67").AutoFilter Field:=1,
Else if R3 = 2 then
ActiveSheet.Range("$R$3:$AA$67").AutoFilter Field:=2,
else if R3=3 then
ActiveSheet.Range("$R$3:$AA$67").AutoFilter Field:=3,
end if
The part I don't know how to write is the "R3=<value>" portion, and I'm not sure if I structured the if, else if part correctly. Please help!
Bookmarks