Posted to microsoft.public.excel.programming

Ardus Petus Ardus Petus is offline

external usenet poster

Posts: 718

HPageBreak Row

r = activesheet.hpagebreaks(1).location.row

Replace 1 with desired PB's number

HTH
--
AP

"Oscar" a écrit dans le message de news:
...
What would be the easiest way to get the row number of certain HPageBreak
(first , fifth...) on active sheet.

Thanks, Oscar.

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
need help with hpagebreak	btm	Excel Programming	3	July 5th 05 01:25 PM
hpagebreak and vpagebreak	btm	Excel Programming	6	July 5th 05 01:10 PM
Hpagebreak help needed please	Lars Kofod	Excel Programming	3	November 28th 03 03:14 PM
HPageBreak dosen't f...... work	Lars Kofod	Excel Programming	0	November 27th 03 03:23 PM
HPageBreak	billQ	Excel Programming	1	July 24th 03 02:18 AM

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

About Us

"It's about Microsoft Excel"