need macro to repeat two rows at top of each page

J

jwmbem

I need a macro to repeat rows 23 and 24 at top of each page. I must use page
set up to add rows 3 &4 so can't use it for rows 23 and 24 as well. Please
write macro as I would use it, using rows 23 and rows 24 to repeat at top of
each page.
thank you
 
J

JLGWhiz

I have tried several different ways to get those five rows to print without
having to put them somewhere on the sheet in contiguous arrangement and it
just won't do it. Even if you manually set two rows in the page set up, the
VBA code will override what you put in because it uses the page set up to set
the rows to print also. Looks like you will have to do some cutting and
pasting.
 
J

jwmbem

Whiz,..thanks mucho..so far cut and paste is it but it stays on page one as
well..many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top