View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
amepluie amepluie is offline
external usenet poster
 
Posts: 4
Default Insert row after pagebreak

I have a set of data with several horizontal pagebreaks.
I would like to write a macro which insert 2rows after a pagebreak is
found.

The idea I have is use .Count and if it's true, return the .Location
and Insert row.
But I don't know how to exactly write the codes

Greatly appreciate if someone can help.
Thanks.