Dynamic Named Range

[nigelk]

Hi all,

I have a subroutine that runs on a timer and a chart liked to some data.

Every run through means more data is added.

Is it possible to create a named range that on the first run, gets its data from
A2:A11, then on the second run A3:A12, third, A4:A13 etc,etc.


Thanks,Nigel.

 

[JoeMo]

Maybe offset the range after each run:

Dim rng as Range
Static ctr as long

set rng = Range("A2:A11").offset(ctr,0)
'rest of code