repeat rows pattern through pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top