lngend

  1. W

    Excel VBA - Date Filter AND blanks

    I would like to filter data between two dates AND blank. I could do the part for filter data between two dates, but I have trouble with filtering the blank as well. My code is as follows, please help, Sub Filter() Dim lngStart As Long, lngEnd As Long Sheets(“Sheet1”).Select lngStart =...
  2. S

    Macro : IF Condition is not met

    Good day. I would like to ask help regarding conditional setup. So I have a dates that will be filtered based on the condition and will copy paste it. My problem right now is if the condition dates are not available, it will copy all the information. So if the condition dates are not available...
  3. T

    Macro is not filtering properly

    Hi All, Today, without any main changes in my Workbook, I found out that one of my option doesn't work. My function is filtering database basing on values from Data Validation, that's part of my code: ... If Worksheets("MENU").CheckBoxes("CheckBox1").Value = 1 Then Dim lngStart As...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top