Select Range

[samot79]

Hi,

Once again in trouble and I turn to the very helpful forum

How do I write code to select rows 1:101 where column to select is defined as an variable. This clearly doesnt work,

cells(1:101, MatchID).select

But I think it is a good example to show what I like to do.

[fredlo2010]

try this

Cells(1, MatchID).Resize(101).Select

[Norie]

What is MatchID?

If it's a column number and you want to select rows 1 to 101 of the column it represents try this.

Intersect(Range("1:101"), Columns(MatchID)).Select

[samot79]

Works like a charm So helpful this forum, thanks a lot!