Hi all,

Sorry if this is asked often, but I'm trying to do a lot of programmatic work with ranges, but with some level of abstraction from actual worksheets.

All documentation and instances of how to work with ranges and their various methods tends to center around working with known, actual cells in a worksheet: "Range("MyRange")("A1:B5").Select" or something along those lines.

But what if my range isn't anchored to a (known) specific cell in a worksheet? What kind of syntax is valid for selecting: "Range("MyRange")( [whatever cell is the 4th row,2nd column] : [whatever cell is the 5th row, 4th column ).Select" ?

I've tried using various forms of the syntax found at http://support.microsoft.com/kb/291308 , but those all just return "Type mismatch" errors.

Abstracted, programmatic ranges with Excel/VBA (what little I understand of it) has been the Holy Grail for me! I'd love to be able to build, add to, subtract lists without tying them down to worksheets, but I can't ever seem to find workable syntax. Every search for "dynamic" all still comes back to examples with things like A1 or $A$1 in them, they're all about selecting worksheet cells; no abstraction. Even when I do have cells, I don't necessarily know where they are in the sheet, I only know their relative position in the named range. Yes, things like OFFSET(blah, blah) might be useable but there's the trick of knowing how to use them syntactically, which I don't.

I'm hoping there are some folks here who can help me out!

Thanks
-H.R. Calcnstuf