In the VBE, you can put your cursor in the word/method you are interested in
learning about and press F1, this will take you directly to the help section
it is in.

I just read some books, check this forum out a lot and you come across a lot
of functions that other people use, then learn about it. It takes time but
you can catch on quickly.
--
Cheers,
Ryan


"Mervyn Thomas" wrote:

PS with all these methods how do you find in the VB help the various
options in your StrConv(nm.Value, vbProperCase) ? Or is their a decent
manual somwehere? I would much prefer being able to find it myself rather
than bother you guys!
Thanks again!
Mervyn

"Mervyn Thomas" wrote in message
...
I particularly liked this solution but thanks to everyone who answered
"JLGWhiz" wrote in message
...
Sub dk()
Dim nm As Range
For Each nm In Range("A2:A25") 'substitute actual range
nm = Next

End Sub


"Mervyn Thomas" wrote in message
...
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?







.