- Joined
- Aug 10, 2007
- Messages
- 1
- Reaction score
- 0
THe code for the left function is there, but somehow it doesn't work, everytime I try to run it. It show me that me : "Compile error" Wrong number of arguments or invalid property assignment
All help are appreciated, thank you.
(Yah I am new to th macro, still learning)
Option Explicit
Public Sub Leftabc()
Dim word1 As String
word1 = Left("Amanda B. Reckonedwith", 6)
MsgBox "The name is" & " " & word1
End Sub
All help are appreciated, thank you.
(Yah I am new to th macro, still learning)
Option Explicit
Public Sub Leftabc()
Dim word1 As String
word1 = Left("Amanda B. Reckonedwith", 6)
MsgBox "The name is" & " " & word1
End Sub