How to use frequency function in code

[jazztech]

Hi All,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a large amount of data to process with the frequency function. The data_array and bin_array are changing from file to file, however the bin_array is always evenly distributed and symmetric i.e -200, -150, -100 …. 100, 150, 200.
<o></o>
The user has to input 4 variables, two to describe the bin_array by the highest abs value of the bin (200 in the above example) and the bin_width (10 in the above example).
The other two variables indicate where is the data in the spreadsheet to process by the letter of the column and the number of the first row containing the data.
<o></o>
The code so far:
<o></o>
Sub frequency()<o></o>
<o></o>
Dim FirstRow As Integer<o></o>
FirstRow = InputBox(prompt:="FirstRow", Default:=18)<o></o>
<o></o>
Dim DataCol As String<o></o>
DataCol = InputBox(prompt:="Data Column", Default:="b")<o></o>
<o></o>
Dim MaxBin As Integer<o></o>
MaxBin = InputBox(prompt:="Max Bin", Default:=200)<o></o>
<o></o>
Dim BinWidth As Integer<o></o>
BinWidth = InputBox(prompt:="BinWidth", Default:=10)<o></o>
<o></o>
<o></o>
<o></o>
End Sub
<o></o>
My question is, how could I use the frequency function in the code with the above variables and display the results in the original sheet?
<o></o>
Any hint would be greatly appreciated!
<o></o>
Thanks!
<o></o>
Jazztech
<o></o>
<o></o>

 

[jazztech]

Previously I was spoiled with quick and brillinat answers. But this time nobody is there to point me to the right directions..?

Please, please!

Jazztech