variable range

  • Thread starter Thread starter John
  • Start date Start date
J

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