Lcase error

[davidam]

This seems ridiculously simple, but I cannot make this work:

Public Sub Lcase()
Dim caseStr As String
caseStr = Range("F3").Value
Range("A10").Value = Lcase(caseStr)
End Sub

Thanks!
It highlights the expression Lcase, and says wrong # arg or invalid prop assignment

 

[Jonmo1]

Don't name your sub after a built in VBA function..

Change
Public Sub Lcase()

to
Public Sub MyLcase()

Hope that helps.

 

[hiker95]

davidam,

You can not use a VBA Function as the name of your Sub.

Try:

Public Sub MyLcase()
Dim caseStr As String
caseStr = Range("F3").Value
Range("A10").Value = Lcase(caseStr)
End Sub

 

[davidam]

Yikes... I've have made that mistake before...
Thanks

 

[MrKowz]

Might I ask why not just use this formula?

=LOWER(F3)

 

[Scott Huish]

While I also think that if you are using this directly in the spreadsheet you my as well use the built in function LOWER.

However, I would like to comment on your code. You use 2 lines to declare and assign a value to a variable. If that's all you're doing it with it, I would discard that and reduce the whole thing to 1 line of code:

Sub MyLcase()
Range("A10") = LCase(Range("F3"))
End Sub

 

[davidam]

You are both correct for sure. I am using this function is a vb script and I was have trouble with it, so this, with the variables etc, was just for my edification. Many thanks to all for the input; it is appreciated!