Word Frequency Macro

[neucool]

Hello,

I know close to nothing about macros, but I needed one to find the frequency of words in a column. I found a macro that is approximately what I need, and it was working on my work computer (PC) but does not work on my Mac version of Excel.

It is the Pivot Table section that is highlighted when I hit debug.

This is the macro:

Please Login or Register  to view this content.

Any idea as to what's going on?

[JieJenn]

I think this might be more useful

http://www.get-digital-help.com/2011...ord-frequency/

[neucool]

This didn't work for me. All of the places there should have been values said #VALUE, even in the example file.

[Cutter]

@ neucool

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[neucool]

I see, thank you.