Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro not working in 2007
I had the below macro to change text into Uppercase in Excel 2003 but now in
2007 it doesn't work. It seems to get stuck on the For Each x. Can anyone tell me why? Thanks Rick Sub Uppercase() ' Loop to cycle through each cell in the specified range. For Each x In Range(Selection, Selection.End(xlDown)) ' Change the text in the range to uppercase letters. x.Value = UCase(x.Value) Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
F2 Key not working in Excel 2007 | Excel Discussion (Misc queries) | |||
Working Between Excell 2003 & 2007 | Excel Worksheet Functions | |||
Watch Window not working in 2007 | Setting up and Configuration of Excel | |||
Excel 2007 - sum function not working | Excel Worksheet Functions | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) |