Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application-Defined or Object-Defined Error on simple code
I have the following code that produces an Application defined or
object defined error: Sub SortStyleList() Dim SortRange As Range With Sheets("Cost&Margin") SortRange = .Range(.Range("C1002"), Range("c1002").End(xlDown)) UnprotectAll SortRange.Sort Key1:=.Range("C1002") ProtectAll End With End Sub But the following code works flawlessly. Range("C1002", Range("C1002").End(xlDown)).Select Selection.Sort Key1:=Range("C1002") I do not want to select the range. What am I doing wrong? Thanks, Brent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Application-defined or object-defined error on copy | Excel Programming | |||
Application-defined or object-defined error - missing the basics | Excel Programming | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming |