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

repeat rows pattern through pages
 

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

repeat rows pattern through pages
 

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