JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
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
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