Moving a range of cell to the next page!

[sjurisic]

Hi All,

I got stuck at a silly problem:

- I have a worksheet that is getting dynamicaly updated through XML interface; Sometime, it is only 1 page - sometime, it can be 3 or 4 pages; No rules here!

- I have a range of cells (6rows x 4cols),at the end of the page, that can not be split between two pages; In other words, I need a code that would check if cell named "total" is located in last five rows of the current page;

If so, macro needs to select cell "total" and to move it to the first cell ( first row) of the next page;

MANY THANKS!

 

[Andrew Poulsom]

Do you mean you want to insert a Page Break in the cell that contains "total"?

Can you post a sample of your spreadsheet?

 

[sjurisic]

sample.xls
	A	B	C	D	E	F	G	H	I
1			MSPRemittanceforperiod:	Nov.18.2003
2
3	Seq#	Doctor	PatientName	PHN	VisitDate	Status	Claimed	Paid	ExpCode
4
5	0000055	JaniceLa	SavaJurisic	123456789	Nov.21.2003	Rejected	23.00	0.00	VX
6	0000056	CharlesHsiao	SavaJurisic	123456789	Nov.28.2003	Paid	23.00	23.00
7	0000055	JaniceLa	SavaJurisic	123456789	Nov.21.2003	Rejected	23.00	0.00	VX
8	0000056	CharlesHsiao	SavaJurisic	123456789	Nov.28.2003	Paid	23.00	23.00
9	0000055	JaniceLa	SavaJurisic	123456789	Nov.21.2003	Rejected	23.00	0.00	VX
10	0000056	CharlesHsiao	SavaJurisic	123456789	Nov.28.2003	Paid	23.00	23.00
11	0000055	JaniceLa	SavaJurisic	123456789	Nov.21.2003	Rejected	23.00	0.00	VX
12	0000056	CharlesHsiao	SavaJurisic	123456789	Nov.28.2003	Paid	23.00	23.00
13	0000055	JaniceLa	SavaJurisic	123456789	Nov.21.2003	Rejected	23.00	0.00	VX
14	0000056	CharlesHsiao	SavaJurisic	123456789	Nov.28.2003	Paid	23.00	23.00
15	0000055	JaniceLa	SavaJurisic	123456789	Nov.21.2003	Rejected	23.00	0.00	VX
16	0000056	CharlesHsiao	SavaJurisic	123456789	Nov.28.2003	Paid	23.00	23.00
17
18		ClaimStats:	Paid	Held	Rejected	Total
19			34	4	2	40
20
21		TotalPaid:	782.13
22		TotalHeld:	46.00
23		TotalRejected:	98.56
24		TotalClaimed:	974.60
Activity Report