Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I want to use the worksheetFunction.frequency function in VBA to generate a frequency list of data. I don't know how to return the result into the spreadsheet.Manually, I can do it with an array function. sub test() set myBin = Range("A1:A10") set myData= Range("C1:D20") ?? = WorksheetFunction.Frequency(myData, myBinRange) End sub Any help? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
WorksheetFunction help | Excel Discussion (Misc queries) | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
worksheetfunction | Excel Programming | |||
Worksheetfunction | Excel Programming | |||
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? | Excel Programming |