Dim myRange as Range

Set myRange = Selection.resize(7,1) 'as an example

"Alberto Ast" wrote:

I have selected row 7 and now I want to grow my selection to a variable
number of rows.... how do I do it.