Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 360
Default trying to count the pagebreaks in the immediate window

How come when I do this in the immediate window I get a runtime error?

?activesheet.hpagebreak.count

tia,
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default trying to count the pagebreaks in the immediate window

"s" needed:

HPageBreaks

--
Jim
"Janis" wrote in message
...
| How come when I do this in the immediate window I get a runtime error?
|
| ?activesheet.hpagebreak.count
|
| tia,


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 857
Default trying to count the pagebreaks in the immediate window

you missed an "s"..

?activesheet.hpagebreaks.count

--
Hope that helps.

Vergel Adriano


"Janis" wrote:

How come when I do this in the immediate window I get a runtime error?

?activesheet.hpagebreak.count

tia,

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default trying to count the pagebreaks in the immediate window

I thought you had the HPageBreaksssss resolved.

"Janis" wrote:

How come when I do this in the immediate window I get a runtime error?

?activesheet.hpagebreak.count

tia,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Lost sum,count,averge,etc shortcut window Suzanne Excel Discussion (Misc queries) 2 June 6th 08 04:08 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
Count & Select Window Edmund Excel Programming 5 October 16th 06 10:13 AM
Excel PageBreaks and the Rows to Count thereof [email protected] Excel Programming 2 December 30th 05 12:34 AM
pagebreaks Yiannis H. Economides Excel Programming 1 February 19th 04 04:03 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"