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

Use Resize, not Offset...

Rows(7).Select
HowManyRows = InputBox("How many rows total did you want to select?")
Selection.Resize(HowManyRows).Select

--
Rick (MVP - Excel)


"Alberto Ast" wrote in message
...
I have selected row 7 and now I want to grow my selection to a variable
number of rows.... how do I do it.

Use,

Dim N As Long
N = 10
Selection.Resize(N).Select

This will resize the selection to N rows with the same number of
columns as the were in the original selection. It assumes N 0.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 17 Oct 2009 12:38:01 -0700, 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.

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.