Excel formula question

[Dillinger4]

Anyone know if i can use the lower formula with a range of cells? Im at work now and i have a huge workbook that i need to convert too all lowercase. The lower formula seems to only be able to be applied to one cell. . Thanks.

[westconn1]

i tested this on a small worksheet, do convert the whole sheet to lower case

Dim mysheet As Worksheet, rng As Range, cell As Range, r, c
Sheets("Sheet1").Activate
Set mysheet = Sheets("Sheet1")
myrow = mysheet.Cells.SpecialCells(xlCellTypeLastCell).Address 'last row
mycell = "a1:" & myrow
        On Error Resume Next
Set rng = mysheet.Range(mycell)
 
For r = 1 To rng.Rows.Count
    For c = 1 To rng.Columns.Count
        Set cell = rng.Cells(r, c)
        Debug.Print cell.Address
        cell.Value = LCase(cell.Value)
    Next
Next

pete

[RobDog888]

Looks like you can specify a range for the formula but it returns the #Name error.
=LOWER(A1:M40)

You get the blue outline range indicator but doesnt work.

[Dillinger4]

Yeah i just gave up on it. The auto complete kept adding existing entries in caps so i had a mixture of caps and non capped cells. My boss told me to just forget about it and email it to this dude. Excel kept yelling about having a circular reference.