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!!

 

[hiker95]

pedie,

What is in cell A1?

 

[pedie]

Like names..

Suppose I write in cell a1, PETER, when i run the macro i want it to look like

Peter

 

[hiker95]

pedie,


Try:

Sub Selection_proper()

Range("A1").Value = WorksheetFunction.Proper(Range("A1"))

End Sub

 

[Weaver]

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

 

[pedie]

tHAT was fast..Great guys!!! Thanks HIcker95 & everyone!!!

 

[pedie]

Sub Selection_proper()

Range("A1:A4").Value = WorksheetFunction.Proper(Range("A1:A4""))

End Sub

when i try to use this in dif cells it doesnt work

 

[meldoc]

Hello

Try.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Selection_proper()<br>  <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> cel <SPAN style="color:#00007F">In</SPAN> Range("A1:A4")<br>    cel.Value = WorksheetFunction.Proper(cel)<br>  <SPAN style="color:#00007F">Next</SPAN> cel<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[pedie]

Thanks m gonna try right now!!!

 

[pedie]

eXACTly what I was looking for ..Great thanks alot!!!