Variable time period/cell reference

Help!

I'm writing some VBA that needs to refer to a cell in which the user will have input the time period they are interested in.
The macro needs to clear the contents outside of this time period and blank out the cells. (see example)
I can work out most of it but i cannot work out how to indicate which range of cells need to be cleared and blanked.

Any help would be great thanks.

Hi

Assuming that your cell to nominate the number of years is C3, and your data is in row 7 with your first reference cell being B7 then

Range("B7").Resize(1, Range("c3").Value).Select

would select the relevant range. However, if you are just clearing the entries, then you don't need to select it first

Range("B7").Resize(1, Range("c3").Value).ClearContents

would just clear it out.

rylo