variable range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 21 Jul 2006 02:29 GMT

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

Reply to this Message

protonLeah - 21 Jul 2006 04:26 GMT

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?

Signature

protonLeah

Reply to this Message

John - 21 Jul 2006 15:42 GMT

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

> 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?

Reply to this Message