Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LTrim
I'm getting an error for the following code:
Dim strText1 As String, strText2 As String .... strText2 = LTRIM(strText1) The error is "Wrong number of arguments or invalid property assignment" The code looks exactly like the example in the help file. Anyone know why am I getting this error? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
LTrim
Looks fine to me...in a standard module:
Sub Test1() MsgBox MyTrim(" A B C ") End Sub Function MyTrim(strText1 As String) As String Dim strText2 As String strText2 = LTrim(strText1) MyTrim = strText2 End Function I used a function so that it could be called from a sub as in the test above, or from a worksheet cell. Patrick Molloy Microsoft Excel MVP -----Original Message----- I'm getting an error for the following code: Dim strText1 As String, strText2 As String .... strText2 = LTRIM(strText1) The error is "Wrong number of arguments or invalid property assignment" The code looks exactly like the example in the help file. Anyone know why am I getting this error? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't seem to use RTRIM or LTRIM in Excel 2002. I want to trim. | New Users to Excel |