View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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