View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Garry[_8_] Garry[_8_] is offline
external usenet poster
 
Posts: 5
Default Newbie Q: Range from two cells

Hi All:

I'm pretty familiar with Word VBA and am now blundering around Excel. A
few successes so far. I find the trickiest thing so far is adapting
myself from Word's range object to Excel's.

An elementary question. I have two variables, representing two cells in
the same column. What is the easy way to return a range = to all the
cells between (and including) the two? So far my untutored brain can
only think of a complicated statement involving offsets and resizes.


Oh.. if there are any traps-for-young-players a newbie should know, I'd
appreciate it.

Thanks for your time,
Garry