software

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

quot;juststarterquot; wrote:

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

quot;Duke Careyquot; wrote:

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