Marty
10-24-2016, 12:48 PM
Hi,
I would need your expertise. In my macro, i am filtering by a fix range, but this range can change from another file that could be for instance 7600 lines instead of 7491 lines
Is there a formula that I can write for the FILTER to filter until end of a selection, so if the quantity of line changes all the time i can have a dynamic and not static range ?
Example :
Range("O7491").Select
Range(Selection, Selection.End(xlUp)).Select
**this range could be more or less than 7491.
Any help is appreciated as always,
thanks
Marty.
I would need your expertise. In my macro, i am filtering by a fix range, but this range can change from another file that could be for instance 7600 lines instead of 7491 lines
Is there a formula that I can write for the FILTER to filter until end of a selection, so if the quantity of line changes all the time i can have a dynamic and not static range ?
Example :
Range("O7491").Select
Range(Selection, Selection.End(xlUp)).Select
**this range could be more or less than 7491.
Any help is appreciated as always,
thanks
Marty.