repeat rows pattern through pages

Hello,
I i am fill an excel worksheet using vb.net. The data to enter are for
example : serial number, name and age. I have created the first page of the
excel file (title , margins, bold lines between cells (i mean the grid) etc)
and it works fine as long as data provided fit in one page... If data exceeds
the first page then the format is not there. I know it's not supposed to be
there :-) but is there a way to instruct excel to recreate the first page's
pattern to the rest of the pages (especially the grid)?
Thx a lot
theodore

You can copy the existing worksheet's UsedRange, then on the new worksheet
execute a

..PasteSpecial xlPasteFormats

"juststarter" wrote:

> Hello,
> I i am fill an excel worksheet using vb.net. The data to enter are for
> example : serial number, name and age. I have created the first page of the
> excel file (title , margins, bold lines between cells (i mean the grid) etc)
> and it works fine as long as data provided fit in one page... If data exceeds
> the first page then the format is not there. I know it's not supposed to be
> there :-) but is there a way to instruct excel to recreate the first page's
> pattern to the rest of the pages (especially the grid)?
> Thx a lot
> theodore

I dont want neither to use the pasting on another workseet (i want to use it
on consequent pages of the same workseet) or use vb.net (or vba). I am asking
if there is a way - as an excel end user - to create something like a
repeating pattern for each page of a worksheet

"Duke Carey" wrote:

> You can copy the existing worksheet's UsedRange, then on the new worksheet
> execute a
>
> .PasteSpecial xlPasteFormats
>
> "juststarter" wrote:
>
> > Hello,
> > I i am fill an excel worksheet using vb.net. The data to enter are for
> > example : serial number, name and age. I have created the first page of the
> > excel file (title , margins, bold lines between cells (i mean the grid) etc)
> > and it works fine as long as data provided fit in one page... If data exceeds
> > the first page then the format is not there. I know it's not supposed to be
> > there :-) but is there a way to instruct excel to recreate the first page's
> > pattern to the rest of the pages (especially the grid)?
> > Thx a lot
> > theodore