<div>
Thanks for the quick response, I tried the offset thing but just couldnt get it to work. Yours, of course has the correct syntax.<br />
Thanks again for your help
</div>


Thanks for the quick response, I tried the offset thing but just couldnt get it to work. Yours, of course has the correct syntax.
Thanks again for your help

<div>
Glad to help but thank you for the prompt grade and comment.<br />
<br />
Chris
</div>


Glad to help but thank you for the prompt grade and comment.

Chris

<div>
<div class="content wysiwyg-content">
Hi there,<br />
I can make a range dynamic by creating a table but i want to make a dynamic range that is the last 8 rows of a column, column B for example. The column is added to each week and i need to always refer to the last 8 rows, so that i can name the range and set it as a series in a chart.<br />
As always your time is appreciated.
</div>
</div>


Hi there,
I can make a range dynamic by creating a table but i want to make a dynamic range that is the last 8 rows of a column, column B for example. The column is added to each week and i need to always refer to the last 8 rows, so that i can name the range and set it as a series in a chart.
As always your time is appreciated.

changing dynamic range

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.