View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce Roberson Bruce Roberson is offline
external usenet poster
 
Posts: 47
Default Select two consecutive rows

I know that if I want to select for example a whole column
of contiguous data, that I can select in this manner:

dataRange(Selection, Selection.End(xlDown)).Select
__________________________________________________ ________
However, if I only want to start with selecting two cells,
then I ought to be able to issue a statement like this one
to select the active cell, plus one additional cell right
below. But this doesn't work. Any ideas how to change it?

Range(Selection, Offset(1, 0)).Select
__________________________________________________ _________

Also, someone has gone to sleep today on the posting of
newsgroups on the Microsoft web site where I normally can
get these responses pretty timely. And google always stays
behind. So, it may be a while before I get your post if
you post back a response today. I don't get to use my
favorite method of access newsgroups, Outlook Express when
I'm at work.

Bruce