Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a function that I am using below. I want to be able to pass all the
operators to the variable Operators (i.e.Operators = "+" & "-" & "/" & "*" & "^"). However when I do this, the function fails. It only works when I pass one character to the variale. How I do pass more than one character to this variable and then have it work proplerly in the Split function? Thanx Function functionseparator(str As String) As String Dim Operators As String Dim temp Operators = "+" temp = Split(str, Operators) functionseparator = temp(UBound(temp) - 1) End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pass variable from one workbook to another | Excel Discussion (Misc queries) | |||
How to pass a variable into an SQL statement | Excel Discussion (Misc queries) | |||
Using Public to Pass Variable | Excel Programming | |||
Pass Variable Question | Excel Programming | |||
How to pass variable value between macros | Excel Programming |