ExcelBanter - trying to count the pagebreaks in the immediate window

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - trying to count the pagebreaks in the immediate window (https://www.excelbanter.com/excel-programming/396469-trying-count-pagebreaks-immediate-window.html)

Janis

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,

Jim Rech

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,

Vergel Adriano

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,

JLGWhiz

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,

All times are GMT +1. The time now is 08:12 PM.