LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleted columns reset their width to zero Dave O Excel Discussion (Misc queries) 4 October 30th 08 12:10 AM
Create a macro which takes a column name and width and sets the column width to what it should be Ag Excel Programming 4 September 29th 07 11:29 PM
How to make cell width different than the column width it lies in John Excel Discussion (Misc queries) 2 September 11th 06 10:41 PM
Set Column Width Based On Total Width Of Other Columns rayneraingoaway Excel Programming 1 June 28th 06 11:10 PM


All times are GMT +1. The time now is 04:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"