B
Bruce Roberson
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
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