Someone, please help with this simple macro...stucked..!!! Thanks

[pedie]

Sub Selection_proper()
Range("a1").Select
Selection.Value = Proper
End Sub

I have this code which doesn't work instead it deletes the contant in a1.

I want the value of a1 to be Proper when i run the macro.

THanks!!

 

[mortgageman]

Probably because VB thinks 'proper' is a variable in this context and since it hasn't been defined, it will return the default value of null. This results in your data being deleted.

With selection
.value=worksheetfunction.proper(.value)
end with

Ought to work

One way to avoid this problem in the future is to always start off your macro projects with "Option Explicit"

Gene Klein