Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone explain this to me?
From the immediate window: ?Range("A1").Item(3,1).address $A$3 ?Range("A1").Item(3).address $A$3 ?Range(Range("A1"), Range("G10")).Item(3,1).address $A$3 ?Range(Range("A1"), Range("G10")).Item(3).address $C$1 <----!!!??? The last one there is where my confusion lies. I'm sorting a range with the code below(rough example): --------------------------------------------------------------------------------------------- Set rDataRng = Range(Range("A1"), Range("G10")) With rDataRng .Value = .Value .Sort Key1:=.Item(2, 1), Order1:=xlDescending, OrderCustom:=1, _ Orientation:=xlLeftToRight End With --------------------------------------------------------------------------------------------- I initially had .Item(2) in there as the Key1 entry, which caused me to stumble upon this (what I see as) strange behavior. Is this a bug or one of those "by design" features? Thanks for any input. -Jeremy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strange behavior | Excel Discussion (Misc queries) | |||
Strange behavior | Setting up and Configuration of Excel | |||
Strange behavior. | Excel Discussion (Misc queries) | |||
Strange PrintOut Behavior | Excel Programming | |||
Help with very strange cell behavior | Excel Programming |