Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column width reset
I have just started to experience a very strange problem that
hopefully someone may recognise. Note that this only happening on my machine and the code runs perfectly well on other machines . The problem has only come to light since our support desk made a change to my Windows profile. The problem may be caused by this change but I am hoping expert Excel resources may be able to help explain the problem. I have code to populate worksheets with data, within which I check for pagebreaks and add lines and text to get around natural constraints that Excel has for page headers. However, when I run the following line (even if this returns False) Excel changes the column widths of columns to a large random value (usually 255 pts) If Worksheets(strsheetname).Rows(introw).PageBreak < xlNone Then In have stepped through the code and actually can see the worksheet format change as this line is processed. Thanks for any feedback. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column width reset
I have no idea why it would cause this problem but since you've had your
profile changed and because it involves printing, I'd suggest seeing what happens if you change to another printer. Even a pretend one like Adobe or MS XPS in the File, Print dialog. -- Jim "Andy Thomas" wrote in message ... |I have just started to experience a very strange problem that | hopefully someone may recognise. | | Note that this only happening on my machine and the code runs | perfectly well on other machines . The problem has only come to light | since our support desk made a change to my Windows profile. The | problem may be caused by this change but I am hoping expert Excel | resources may be able to help explain the problem. | | I have code to populate worksheets with data, within which I check for | pagebreaks and add lines and text to get around natural constraints | that Excel has for page headers. However, when I run the following | line (even if this returns False) Excel changes the column widths of | columns to a large random value (usually 255 pts) | | If Worksheets(strsheetname).Rows(introw).PageBreak < xlNone Then | | In have stepped through the code and actually can see the worksheet | format change as this line is processed. | | Thanks for any feedback. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column width reset
Thanks Jim, though printing isn't involved. This behaviour occurs
when formatting data on a spreadsheet. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column width reset
Andy-
I know you weren't print. That's not the point. Excel uses the print driver internally anytime you do something involving printing, like setting page breaks. -- Jim "Andy Thomas" wrote in message ... | Thanks Jim, though printing isn't involved. This behaviour occurs | when formatting data on a spreadsheet. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column width reset
Thanks Jim - I've changed printers and this has sorted it. Thanks
again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleted columns reset their width to zero | Excel Discussion (Misc queries) | |||
Create a macro which takes a column name and width and sets the column width to what it should be | Excel Programming | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Set Column Width Based On Total Width Of Other Columns | Excel Programming |