Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lower case
How can can I adjust the program below to:
Sheets("Sheet1").Select cell = Columns("A:A").Select '***PROGRAM START******* Sub ChangeFromUpperToLowerCase() Dim cell As Range For Each cell In ActiveSheet.UsedRange If Not cell.HasFormula Then cell.Value = LCase(cell.Value) End If Next cell End Sub '***PROGRAM END******* Thanks in advance. Maperralia |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lower case
Pls post only once. See other post for answer
-- Don Guillett SalesAid Software "maperalia" wrote in message ... How can can I adjust the program below to: Sheets("Sheet1").Select cell = Columns("A:A").Select '***PROGRAM START******* Sub ChangeFromUpperToLowerCase() Dim cell As Range For Each cell In ActiveSheet.UsedRange If Not cell.HasFormula Then cell.Value = LCase(cell.Value) End If Next cell End Sub '***PROGRAM END******* Thanks in advance. Maperralia |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lower case
'***PROGRAM START*******
Sub ChangeFromUpperToLowerCase() Dim cell As Range Sheets("Sheet1").Select Range("A1").Select Range(ActiveCell, Cells(Rows.Count, ActiveCell.Column).End(xlUp)).Select For Each cell In Selection If Not cell.HasFormula Then cell.Value = LCase(cell.Value) End If Next cell End Sub '***PROGRAM END******* Gord Dibben MS Excel MVP On Tue, 25 Apr 2006 10:19:02 -0700, maperalia wrote: How can can I adjust the program below to: Sheets("Sheet1").Select cell = Columns("A:A").Select '***PROGRAM START******* Sub ChangeFromUpperToLowerCase() Dim cell As Range For Each cell In ActiveSheet.UsedRange If Not cell.HasFormula Then cell.Value = LCase(cell.Value) End If Next cell End Sub '***PROGRAM END******* Thanks in advance. Maperralia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions |