You put the code in a standard module
You put the code in a standard module
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you for the earlier answer.
I attached a picture. This is a standard module?
Yes, that is a standard module. Just paste the code in, alone. You do not need to add any other code, like you did here:
Then in your spreadsheet you can use the function like this:![]()
Sub Macro1() ' ' Macro1 Macro ' '
=SplitText(A1,5,10)
or whatever arguments are appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks