VBA help to select value with most occurences

[ssmith001]

I am looking for some assistance with VBA code for Excel to help me find the value of a range of cells that has the greatest number of occurrences of a number. Not sure I explained that correctly so here's the data in column A


734
734
827
277
198
124
350
182
734
734
837
199
201
734

What I want to come out of this is a variable with the number 734 in it, since that number occurs the most.

 

[Rick Rothstein]

Try this...

=MODE(A1:A14)

 

[ssmith001]

Thanks Rick. I'm not sure how to use this function in VBA. Can you explain?

 

[Rick Rothstein]

Thanks Rick. I'm not sure how to use this function in VBA. Can you explain?

Sorry, I overlooked the VBA part of your question. Try this...

MostFrequentNumber = WorksheetFunction.Mode(Range("A1:A14"))

 

[ssmith001]

perfect. Thanks Rick!