I didn't post enough info - my apologies.

With a dynamic range name below I can refer to a range starting in A1 extending down by the number of non-empty cells in Column A.

ie
Insert - Name - Define
Name: MyRange
refers to =OFFSET($A$1,0,0,COUNTA($A:$A),1)

would refer to A1:A10 if there were 10 non-empty cells in Column A

I was wondering if there was a way to create a dynamic range name that refered to say, every tenth non-empty A cell (A1,A11,A21 etc)

Speculative, but interesting

Cheers

Dave