View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Emma Aumack Emma Aumack is offline
external usenet poster
 
Posts: 6
Default Expand a range by rows and columns


Hi All,

I need to know how to expand a range by 2 rows. Here is what I have:

FinalRow = Range("A1").End(xlDown).Select

Now I need to come down 4 more rows and over 14 columns. I don't want to
use Cell References. I want to use relative references if at all possible.

How do I do that???

Your help is much appreciated.
--

Emma
www.bardpv.com
Tempe, Arizona