Hello everyone,

My problem is that I need to automate insertion of pagebreak in an excel
document.

I pull data from database and spit it out on an excel sheet and then I want
to write a short VB application or just a macro which insert page breaks at
a particular places which i will mark on excel sheet while spitting out
data.

so this macro/routine should just look through an entire coulmn in excel
sheet and when it found the mark it will just insert the page break
automatically and replace the mark by null.

I dont have enough experience in writing VBA routines. I would be very
thankful if someone can guide me.

Thanks a lot,

Bilal