Select active row, plus next 21 rows down.

[kmakjop]

Hello,

I am trying to select the active row and the next 21 rows down, so in all 22 rows should be selected after the macro runs.

[Arkadi]

selection being one column by 22 rows? or entire row of selected cell plus 21?

[xladept]

Try:

Please Login or Register  to view this content.

[kmakjop]

the first row, then the next 21 rows down. I have a macro to lookup and find a value in column "A", when it finds it, it also selects the row, i want that row, plus the next 21 rows going down selected.

[Arkadi]

Then xladept nailed it