Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |