Excel Client:GetFilter

From CoPlanner 10
Jump to navigationJump to search

Function

GetFilter(BlattName, FilterName)

Diese Function provides a filter formula of the specified filter in the filter bar.

Parameter Description
BlattName Name of the working sheet, on which the filter is located.
FilterName Name of the filter, which is selcted

Example

GetFilter('Ad-Hoc Bericht';"Company") returns the formula "Company:=Bike GmbH, because "Bike GmbH" was selected in the filter