Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a row to the current Selection
I am using the statments below to select a Range. What I need to do is keep
the current range and Add 1 Row to the current range. Range(Cells(9, 6), Cells(9, colx + 6)).Select Range(Selection, Selection.End(xlDown)).Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a row to the current Selection
Selection.Resize(Selection.Rows.Count + 1).Select
Though you rarely need to select a range in Excel to work with it. HTH, Bernie MS Excel MVP "pokdbz" wrote in message ... I am using the statments below to select a Range. What I need to do is keep the current range and Add 1 Row to the current range. Range(Cells(9, 6), Cells(9, colx + 6)).Select Range(Selection, Selection.End(xlDown)).Select |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Qualifying macro run according to current selection | Excel Programming | |||
Adding current selection | Excel Programming | |||
Capture Current Selection in a Combo Box | Excel Programming | |||
Update on Current Selection | Excel Programming | |||
Calculated value based on current line selection | Excel Programming |