View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Floss Floss is offline
external usenet poster
 
Posts: 7
Default Range selection code in a macro

Below is code I wrote to select multiple rows creating a single range

Sheets("Givens").Activat
Rows("22:22").Selec
Range(Selection, Selection.End(xlDown)).Selec

To get me the correct range I need a set of instruction to modify the above range by decreasing by one row from the bottom of the selection. My attempt was for the 4th instruction "Range(Selection, Selection.xlUp).Select" but unfortunately for me it's an improper syntax

Please help
Thank you in advance.