Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rng(1,1) syntax doesn't work for set rng = arange.columns(1)
Hi Tim:
A wild guess, but possibly a single column is internally defined to be one-dimensional, causing a conflict with the double index. ?Range("B2:X5").Columns(1).Address $B$2:$B$5 ?Range("B2:B5")(1).Address $B$2 However: ?Range("B2:X5").Columns(1)(1).Address $B$2:$B$5 It seems that once you define a range explicitly as a column, the unit becomes the column and not a cell within the column. I'm not expressing the concept very well, but I'm sure you get the gist. Regards, Vasant. "Tim Zych" wrote in message ... Anybody know why this doesn't work? Dim rng As Range Set rng = Range("B2:X5").Columns(1) Debug.Print rng.Address '<- this works Debug.Print rng(1, 1).Address '<-this doesn't Yes, rng.cells(1,1) does work. What's up with this? XL2000, Win2000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arange sorted data in multiple columns | Excel Discussion (Misc queries) | |||
Help to adapt Formula syntax to work with Visible Filtered Cells | Excel Worksheet Functions | |||
Help to adapt Formula syntax to work with Dynamic Named Ranges | Excel Worksheet Functions | |||
rng(1,1) syntax doesn't work for set rng = arange.columns(1) | Excel Programming | |||
rng(1,1) syntax doesn't work for set rng = arange.columns(1) | Excel Programming |