I need a macro to count the number of words in cell A1 sheet1.
Failed example:
Words in cell a1 = "Only if we had a macro to count words"
results:
msgbox says 9
Thanks!
Nicole
Failed example:
Code:
sub countwordsincell()
msgbox countwords(range("a1"))
end sub
results:
msgbox says 9
Thanks!
Nicole