lngstart

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 =...

Hello, I'm creating a User Form and trying to get the starting position of a Combo Box to be the number of the month. For example since it is currently July I would like the Combo Box to start on position 6. When I try this varToday = Date varToday = varToday - 10 'this is purposeful...

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...

Hi all, Good day for you all....... I run this code get run-time error "1004" Autofiter method of range class failed Public Sub MyFilter() Dim lngStart As Long, lngEnd As Long lngStart = Range("m1").Value 'assume this is the start date lngEnd = Range("m2").Value 'assume this is...

Hi OK so this isn't a question, but I couldn't find anywhere else to post it. if a mod spots this and knows a better place for it to go, please move it for me, thanks. I need as part of our Infernal Audit requirements, to document which sheets/external references are made for every sheet in a...

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...

Hi All, I do have an issue with filtering a column between two values, which have a source in a different worksheet as a Data Valuation. I've got a column with dates and times. I need to filter it up between values which are in format: =TEXT(TODAY(), "dd-mm-yyyy")&" 10:00:00" =TEXT(TODAY()...