If the cell containing the string "Temperature" is the active cell then the
row No of the cell above the next blank cell is

rngendrow = ActiveCell.End(xlDown).Row

Regards,
Stefi

€žAmyHomewood€� ezt Ã*rta:

I am creating a macro that will select a range of cells and use them as a
series in a chart. The range of cells will always be bewteen a cell
containing the string "Temperature" and the next blank cell. The location of
this range however, is not fixed.

I can write the code to find the cell containing the string "Temperature"
and move one cell down but cannot work out how to select the range from here
to the cell above the next blank cell.

All help is greatly appreciated,
Amy