Sentence Scrambler Help-- (Solved)

Hi all. I'm trying to rearrange the order of the words randomly within a cell. I'm getting a type mismatch error. Here's what I've got so far:

Please Login or Register  to view this content.

The ShuffleArray function is here: http://www.cpearson.com/excel/ShuffleArray.aspx

If I comment out the ShuffleArray line, everything else works fine. What am I doing wrong?

Hi,

Change the ShuffleArray function signature to this:

Please Login or Register  to view this content.

You will get an error if the activecell is empty so you should add a check for that too.