Skip to Content
Former Member
May 18, 2005 at 04:12 PM

BeX-Analyzer; Set Filter for Value Range with VBA


Hello everyone,

This is my very first post in here and I'm curious if someone of you always already had the same problem to solve!

Setting any single filter values with

Function SAPBEXsetFilterValue(intValue As String, Optional hierValue As String, Optional atCell As Range) As Integer

works fine!

But what, if it's <b>not about setting a single value, but a value range</b>, in my case everything before a specific date (e.g. "< 30.04.2005")

Just using this string as a parameter doesnt work.

Neither works replacing the date in all worksheets (even in the "veryhidden" ones)

The reason for this request is, that I always want to select figures where the date at each line is at least earlier than 10 days ago from today, and I don't want to enter it manually everytime.

Thanks a lot and have a great day!