variable range

[John]

I have a variable n.

I want to select a printarea using n.

like (50,1:n,8)

I can't see how you do that since selecting ranges only uses the "B1"
type of referance for cells, not the (1,2) style.

John

 

[protonLeah]

Range(Cells(r1, c1), Cells(r2, c2)), where:
(r1,c1) are the row,col of the first cell and (r2,c2) are the row, col
of the last cell. From your query, I suppose r2 =n-th row?

 

[John]

thanks... I couldn't find that in the help files.
John