Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range(S) is a valid expression when S = "x,y".
Thought I'd share something I discovered:
Let's say string S = "MyCell1", and MyCell1 is a valid range name. Then of course, expression Range(S) returns the range. Next, let's say string T = "MyCell2", and ditto. Then, Range(S,T) returns a range comprising the two individual ranges. Now, let's say string U = "S,T". Then, expression Range(U) is equivalent to Range(S,T). Namely, it returns the range comprising MyCell1 and MyCell2. That seems kind of amazing. For a param to "resolve into" into "secondary" or "inline" params strikes me, offhand, as the kind of capability you occasionally find in a scripting language that you can't get in a compiled language. *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Excel expression "sumproduct" in Access | Excel Programming |