Applying page break function conditionally on the basis of cell value using macro

Hi gurus,
Presently I need to develop a macro that can apply page break in excel 2002 on the basis of the values of a particular column in the excel

example
CURRENT EXCEL

Print Output in 1st page

Col1 Col2

1 a
0 b
0 c
1 d
0 e
1 f
0 g
0 h


I need to apply page break before the last cell value of col1 when the cell value=1using the macro mentioned below.

EXCEL REQUIRED AFTER APPLYING CONDITIONAL PAGE BREAK USING MACRO
Print Output in 1st page

Col1 Col2

1 a
0 b
0 c
1 d
0 e

Print Output in 2nd page
Col1 Col2

1 f
0 g
0 h


MACRO DEVELOPED SO FAR
----------------------------------------------START------------------------------------------------

Please Login or Register  to view this content.

----------------------------------------------END-------------------------------------------------------------


Please help ASAP
Thanks

I don't understand in your example you show your first page break after 0? is that where you want it or when it finds a 1? also what determines that it shouldn't be the first 1 that it comes across?

I want to apply page break before the last value for Col1=1
In the examle that I mentioned above
Print Output in 1st page

Col1 Col2

1 a
0 b
0 c
1 d
0 e

Print Output in 2nd page
Col1 Col2

1 f
0 g
0 h

In the row where Col2 value = f we get the corresponding Col1 value =1 which is the last Col1 value where it equals 1.
So I want to apply page break before this row in my excel sheet.

I'm sorry but it still makes no sense to me!!!

want to apply page break before the last value for Col1=1

so in your example the page break would come after "0h" as zero is a value, it's just not a positive nor negative value!

How about supplying a workbook with a before sheet that has data similar to that which you will be using with another sheet showing the "after" look.

Hi Simon,
I have uploaded a excel sheet specifying my requirement more clearly .
Hope this will make my case more clear to you.
Please help ASAP.

Thanks