Hi Don
Maybe you have this problem
http://support.microsoft.com/default...b;en-us;210663
My workaround is this
http://www.rondebruin.nl/hpagebreaks.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
wrote in message ups.com...
I have the following line of code that produces something I have never
seen befo
lngHorizBreaks = Worksheets(1).HPageBreaks.Count
When this code executes, it changes the column widths of in the
spreadsheet (I am not kidding, it really does change the column widths
of my columns that have data).
The following line of code does not work as it should:
lngPageBreakRow = ActiveSheet.HPageBreaks.Item(1).Location.Row - 1
The above code worked, but recently a machine was upgarded with SAPGUI
7.10 and then things started going crazy.
I need a workaround to determining the page break row and it looks
like anything associated with HPageBreak is going to cause problems.
I would be interested in any help that someone could provide since the
code works in most machines, but the new changes are causing problems
as stated above.
Regards,
Don