| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
a macro to PROPER text
I would like a macro that would set the "proper" format for the cell selected.
Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
a macro to PROPER text
Hi
Sub SetProper() Dim c As Range For Each c In Selection c.Value = WorksheetFunction.Proper(c.Value) Next End Sub -- Regards Roger Govier "pcor" wrote in message ... I would like a macro that would set the "proper" format for the cell selected. Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
a macro to PROPER text
Thanks. That worked very well. I had thought that to use this macro I could
replace "Proper" with "Upper" or "Lower" but that did not work. So How do I change your macro to change the cell to either UPPER or LOWER format. Thanks Ian M "Roger Govier" wrote: Hi Sub SetProper() Dim c As Range For Each c In Selection c.Value = WorksheetFunction.Proper(c.Value) Next End Sub -- Regards Roger Govier "pcor" wrote in message ... I would like a macro that would set the "proper" format for the cell selected. Thanks |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
a macro to PROPER text
Hi,
For Proper you need to call the worksheet function but for upper and lower you must use UCase and PCase c.Value = UCase(c.Value) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "pcor" wrote: Thanks. That worked very well. I had thought that to use this macro I could replace "Proper" with "Upper" or "Lower" but that did not work. So How do I change your macro to change the cell to either UPPER or LOWER format. Thanks Ian M "Roger Govier" wrote: Hi Sub SetProper() Dim c As Range For Each c In Selection c.Value = WorksheetFunction.Proper(c.Value) Next End Sub -- Regards Roger Govier "pcor" wrote in message ... I would like a macro that would set the "proper" format for the cell selected. Thanks |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
a macro to PROPER text
Many thanks.Worked very well
"Shane Devenshire" wrote: Hi, For Proper you need to call the worksheet function but for upper and lower you must use UCase and PCase c.Value = UCase(c.Value) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "pcor" wrote: Thanks. That worked very well. I had thought that to use this macro I could replace "Proper" with "Upper" or "Lower" but that did not work. So How do I change your macro to change the cell to either UPPER or LOWER format. Thanks Ian M "Roger Govier" wrote: Hi Sub SetProper() Dim c As Range For Each c In Selection c.Value = WorksheetFunction.Proper(c.Value) Next End Sub -- Regards Roger Govier "pcor" wrote in message ... I would like a macro that would set the "proper" format for the cell selected. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change text to proper when text is already in upper? | New Users to Excel | |||
| Macro for proper case | Excel Discussion (Misc queries) | |||
| How can I change text to proper text in multiple cells. | Excel Discussion (Misc queries) | |||
| Macro won't move in proper progression | Excel Discussion (Misc queries) | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Linear Mode
