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.