Hi QTE,

My code returns the values for the whole list, instead of just the
Filtered Visible
cells of the Frequency Results(Freq_Results).

This is because it appears that you are using the named range Freq_Results
(which corresponds to the UN-filtered list) in your formula.

Set an object variable to the filtered cells and use this in your formula
in place of Freq_Results, e.g something along the lines of:

Dim Your existing variables
Dim Rng as range

On Error Resume Next
Set Rng = Range("Freq_Results").SpecialCells(xlVisible)
On Error GoTo 0
' your other code

Range("Frequencies").FormulaArray = ("=Frequency(Rng,Bins)")
'remaining code
..
---
Regards,
Norman


"QTE " wrote in message
...
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/