VBA Right
This is a text and video example of how to write a VBA Right function:
*************************************************************************************
Public Sub GetLastName()
Dim strLastName As String
strLastName = Range("A2")
strLastName = Right(strLastName, 8)
strLastName = Trim(strLastName)
Range("C2") = strLastName
End Sub
*************************************************************************************
Now watch how it's done...
That's all, I hope it helped! If not, feel free to email me at erik [at] vbahowto [dot] com
|
Are you struggling to learn VBA?
If your answer to the above question is yes, then I strongly recommend that you check out these VBA Crash Course videos |
