View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
fernando cinquegrani fernando cinquegrani is offline
external usenet poster
 
Posts: 9
Default Most popular word

"Harlan Grove" ha scritto nel messaggio ...

| Rewrite the function to be more flexible.

correct

| Also eliminate the MsgBox call in a
function - never a good idea.

'MsgBox smax & " (" & n & ")"
see the original thread in microsoft.public.it.office.excel

| Change the second argument to use a word separator other than space.

how? " ", ",",";","!","?","."......

| Change the third and fourth arguments to use different definitions of 'word' as specified
| by VBScript regular expressions.

in VBScript regular expressions there is only one definition of 'word'.
parentheses denotes a 'subexpression'.
.f