View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn Greg Glynn is offline
external usenet poster
 
Posts: 137
Default 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