variable range
 

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

variable range
 

Range(Cells(r1, c1), Cells(r2, c2)), whe
(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?


--
protonLeah


------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=563540

variable range
 

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

protonLeah wrote:
Range(Cells(r1, c1), Cells(r2, c2)), whe
(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?