Too many line continuations

[JTL9161]

I recorded a macro to filter the state indicator "IL" in a worksheet (4000 rows) (Column J). I need to then filter another column (N) within the "IL" for "HMO" When I tried recording the macro I got 400 "IL" rows and the macro stopped recording and the error message was "Too many line continuations"

This amount of 'IL" will vary from day to day. What can I use for the filter (IL) then filter (HMO) option in my macro?

Any help will be appreciated.
James

 

[Norie]

Can you post your current code?

 

[CamFlawless]

If the number of rows in Column W is variable, try something like the following:

[COLOR=#333333]Range("$A$1:$W$" & Range("W" & Rows.Count).End(xlUp).Row)[/COLOR]

 

[JTL9161]

I got it with this below:

Dim rngFiltCol As Range

ActiveSheet.Range("A:W").AutoFilter field:=14, Criteria1:="=HM*", _
Operator:=xlAnd

With ActiveSheet.AutoFilter.Range
Set rngFiltCol = .Resize(.Rows.Count, 1) _
.Cells.SpecialCells(xlCellTypeVisible)
If rngFiltCol.Cells.Count = 1 Then
MsgBox "NO DATA"
Else

End If
End With