Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange probem with capitalization of object
I have two copies of code that I swear are indentical except for the
captialization of an object, which seems to be automatic. Somehow one copy of the code doesn't auto cap the object and it is that copy that works. Code is below: Sub RunAll() For Each Worksheet In Worksheets Select Case Worksheet.Name Case "Report 1" Case Else Worksheet.Activate If ActiveSheet.Name = "BGE" Then _ ActiveSheet.Name = "Sheet999" End Select Next Worksheet End Sub When Name is capped, it doesn't work. With lowercase name it works. I can't seem to replicate the non-capped object because when writing new code it won't let me not capitalize it. I am not sure what I did to get the object not capitalized in the first place. Anyone understand this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange Excel Application Object Behavior | Excel Programming | |||
strange error when assigning macro to a form object! | Excel Programming | |||
FormulaR1C1 gets strange application/object defined error | Excel Programming | |||
Gridline printing probem | Excel Discussion (Misc queries) | |||
excel's probem | Excel Programming |