Data is filtered in-place: I then need to perform a calculation on the
Visible Filtered cells using the Frequency function. My code returns
the values for the whole list, instead of just the Filtered Visible
cells of the Frequency Results(Freq_Results).

Freq_Results=Named Range of All Unfiltered Frequency Results, then
filtered in_place

Frequencies=Named Range Number of Times

Bins=Named Range of Intervals

Range("Freq_Results").SpecialCells(xlVisible).Sele ct
Range("Frequencies").Select
Selection.FormulaArray = ("=Frequency(Freq_Results,Bins)")

Excel Help: -
Frequency Function Overview:
Returns a frequency distribution as a vertical array. For a given set
of values and a given set of bins (or intervals), a frequency
distribution counts how many of the values occur in each interval.

Syntax:
FREQUENCY(data_array, bins_array)

Data_array is an array of or reference to a set of values for which you
want to count frequencies. If data_array contains no values, FREQUENCY
returns an array of zeros.
Bins_array is an array of or reference to intervals into which you want
to group the values in data_array. If bins_array contains no values,
FREQUENCY returns the number of elements in data_array.

Remarks
FREQUENCY is entered as an array formula after selecting a range of
adjacent cells into which you want the returned distribution to
appear.
The number of elements in the returned array is one more than the
number of elements in bins_array.
FREQUENCY ignores blank cells and text.
Formulas that return arrays must be entered as array formulas

Suggestions, Please.


---
Message posted from http://www.ExcelForum.com/