Jonathan Kaye wrote:
<snip>
My problem was that I was running the macro from the Openoffice.org Basic
Macros window (I hit the "Run" button) which gave me the argument not
optional error message. When I enter the macro in the spread sheet it runs
without error which enabled be to correct the macro to this:
Function SimpSet(ProcessString) As String
Dim Position As Integer
Position = InStr(ProcessString, ".")
SimpSet = mid(ProcessString, 1, Position - 1)
end Function
Now entering abc.def in A1 and entering =simpset(A1) in B1 gives me abc in
B1. Hopefully the worst is over.
Jonathan
--
Registerd Linux user #445917 at http://counter.li.org/
Please do not send me copies of list mail. I read the lists. Thanks!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
