Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
page break
Is it possible for a macro to find a word in the cell and
use it as it end point for page break? I will like to have a page break on every cell that have the word "Sales grand total". Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
page break
Turn on the macro recorder
do edit=find type in Sales grand total when it is found, do Insert=PageBreak Turn off the macro recorder. Adapt the recorded code to your needs. Note that if the cells are farther apart than what can fit on a page, that you may not get the results you expect. This only works if the distance can be contained on an entire page. -- Regards, Tom Ogilvy mike wrote in message ... Is it possible for a macro to find a word in the cell and use it as it end point for page break? I will like to have a page break on every cell that have the word "Sales grand total". Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
change page number watermark in page break preview | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |