Posted to microsoft.public.excel.programming

Gaz[_3_]

external usenet poster

Posts: 1

Page break Macro

Hi Experts

I have have data as below

CD01A01
CD22B10
CE10E01
CE15X02
CF16S01

I need a macro that will insert a page break when the second letter changes i.
e. CD items will be on one sheet, CE's will be on another etc

Regards Gaz

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 Page Break Adjustments causes a page break each cell	BKaufman	Excel Worksheet Functions	2	September 10th 10 05:02 AM
Page Break Macro	Crowbar	Excel Programming	1	November 22nd 05 10:08 PM
Page Break Macro	Daniel R. Young	Excel Programming	5	July 26th 05 09:17 PM
Using macro for page break	Sara	Excel Discussion (Misc queries)	2	January 13th 05 09:29 PM
Page break macro	lehigh46	Excel Worksheet Functions	2	November 17th 04 02:00 AM

All times are GMT +1. The time now is 02:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us