Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula from consecutive rows to alternate rows? | Excel Discussion (Misc queries) | |||
Transposing data from consecutive rows into non-consecutive rows | Excel Discussion (Misc queries) | |||
min function on non consecutive rows | Excel Worksheet Functions | |||
PULLING OUT CONSECUTIVE ROWS | Excel Discussion (Misc queries) | |||
Select non-consecutive rows | Excel Discussion (Misc queries) |