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]