Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a bonehead question about using the Frequency function: how do I use
it in VBA? I have address strings for both the data and bin ranges and used the following code: Cells(2, jDiff + 5) = Application.WorksheetFunction.Frequency(DataStr, BinStr) with Binstr = $AI$2:$AI$26 and DataStr = $AE$2:$AE$217; jDiff = 31 (AE) When I run it I get the error: " Unable to get Frequency property of the WorksheetFunction class". Could someone please provide me with one or two lines of code (hopefully) to show how to use it correctly? Thanks for your help! BonsaiBill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | Excel Discussion (Misc queries) | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
Access 2002 VB Module controlling Excel 2002 spreadsheet -Run-time | Excel Programming | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) | |||
Excel 2002 files attached to Outlook 2002 EMails change size | Excel Programming |