Making a dynamic ranged print area that also print rows to repeat at top

[amaan.khowaja]

Dear Friends,
I'm trying to make a dynamic print area that works like a dynamic range which also support the condition of rows to repeat at top;

i am having a data in coloum A to K and i am using the formula

Expand Down as Many Rows as There are Numeric and Text Entries.
=OFFSET($A$1,0,0,COUNTA($A:$A,3),11),

after doing the first step as stated above i opt for an option of rows to repeat at top but when i finish the first step of dynamic range stop working.

can anyone please suggest a wayout.

thanx in advance.

regards

[Debraj Roy]

Hi Amaan,

I hope, Print option is already covers the same.. only print the area.. which have data or text.. and "Rows to repeat at to top"

why do you need extra effort to re-adapt the same..