Setting a range that varies
 

I am trying to create a chart from a range that has dates in Column a
(starting at Row 5) and share value in Column B
THis works
Range("A5:B7").Select
but what I can't find how to do is how to set it from A5 to the last cell
with data in column B rather than B7 because as I add data I want the chart
to update.

I am sure it is very simple.
Any clues please
Stephen

Setting a range that varies
 

cLastRow = Cells(Rows.Count,"B").End(xlUp).Row
Range("A5:B" & cLastRwo).Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stephen English" wrote in
message ...
I am trying to create a chart from a range that has dates in Column a
(starting at Row 5) and share value in Column B
THis works
Range("A5:B7").Select
but what I can't find how to do is how to set it from A5 to the last cell
with data in column B rather than B7 because as I add data I want the
chart
to update.

I am sure it is very simple.
Any clues please
Stephen

Setting a range that varies
 

"Bob Phillips" wrote:


cLastRow = Cells(Rows.Count,"B").End(xlUp).Row
Range("A5:B" & cLastRwo).Select

--
Bob,
Thanks for this. It helped me solve a problem that has been bugging me for 2
days.
HTH

RP
(remove nothere from the email address if mailing direct)


"Stephen English" wrote in
message ...
I am trying to create a chart from a range that has dates in Column a
(starting at Row 5) and share value in Column B
THis works
Range("A5:B7").Select
but what I can't find how to do is how to set it from A5 to the last cell
with data in column B rather than B7 because as I add data I want the
chart
to update.

I am sure it is very simple.
Any clues please
Stephen