holilula
06-07-2017, 04:38 AM
Dear All,
I am trying to find a solution for the following problem since hours and somehow and just canīt get through it.
So what I want to do with my VBA code is to check wether all the dates in column A (beginning with A2 as A1 is the header) is within a specific given date range. The range is mentioned in to cells. let me say from:(P1) to: (Q1)
The dates in cells P1 and Q1 both come from formulas which are settled in the background. e.g. in P1 =today() and Q1=WENN(WOCHENTAG(P1;2)=7;P1-2;WENN(WOCHENTAG(P1;2)=1;P1-3;P1-1))
If a cell in column A has a date which is not in the given dater range, the whole line should be deleted.
I am looking since quiet a while now. I had a code working very slow due to an if-loop-structured-code.
I have heard in other forum that a autofilter function would work faster.
Can anyone help me out with this big (probably only for me) issue.
Thanks and Regards,
holilua
I am trying to find a solution for the following problem since hours and somehow and just canīt get through it.
So what I want to do with my VBA code is to check wether all the dates in column A (beginning with A2 as A1 is the header) is within a specific given date range. The range is mentioned in to cells. let me say from:(P1) to: (Q1)
The dates in cells P1 and Q1 both come from formulas which are settled in the background. e.g. in P1 =today() and Q1=WENN(WOCHENTAG(P1;2)=7;P1-2;WENN(WOCHENTAG(P1;2)=1;P1-3;P1-1))
If a cell in column A has a date which is not in the given dater range, the whole line should be deleted.
I am looking since quiet a while now. I had a code working very slow due to an if-loop-structured-code.
I have heard in other forum that a autofilter function would work faster.
Can anyone help me out with this big (probably only for me) issue.
Thanks and Regards,
holilua