Forum Discussion
I need help creating a formula to call a random word from the Excel Dictionary
I have a need, at work, to create formula in Excel to call a random word from the Excel Dictionary. This word will need the first letter capitalized.
Basically, this will create a Random Word, which I will do twice, then I'll create a few random numbers and a symbol or two. I'll have these assigned a random number, then index them in that order. Basically, a passphrase generator.
I have the formulae to create everything but the random word, and it's stumping me. Please help!
No, Address is a read-only property: you cannot set it.
You use the Select method of a cell to make it the active cell.
You could do this:
Dim CameFrom As Range Set CameFrom = ActiveCell ... <your calculations here> ... CameFrom.Select
Note that CameFrom is a Range variable here, not a String variable.
1 Reply
As far as I know, there is no way to do that.
If you create a list of words in a column on a worksheet, you can use a formula to return a random word from that list.