Handle a value from a Range instead of value of a Cell
I haven't got a clue what you're asking, but can I suggest you look at
the OFFSET keyword.
ie: Range("A1").OFFSET(0,1).VALUE gives the value of A1 plus one
column ("B1")
ie: Range("A1").OFFSET(1,1).VALUE gives the value of A1 plus one row,
plus one column ("B2")
Hope this helps a little.
Grg
|