Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HPageBreak and crazy error (Excel 97)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HPageBreak and crazy error (Excel 97)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Codename - Crazy Method Error! | Excel Programming | |||
Error Driving Me Crazy | Excel Programming | |||
Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code???? | Excel Programming | |||
Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code???? | Excel Programming | |||
Error Handling driving me crazy. Please help | Excel Programming |