I feel really stupid. I can't set the column width.
The following code /should/ shrink the page widths by a factor of two, roughly. Instead, it stops with an error on the col.Width line:
Object required.
What INCREDIBLY OBVIOUS thing am I missing?
Please Login or Register to view this content.
Please Login or Register to view this content.
it's a very misleading error! ;-)
the width property is read-only-you need to set the columnwidth property (to 8.43)
Josie
if at first you don't succeed try doing it the way your wife told you to
Please Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
No need to loop through all columns.
Please Login or Register to view this content.
Oh, FFS... thanks, all. And thanks to jindon for the extra note; I looked for that under Worksheet objects, not Columns objects.
No need to loop through all columns.Actually, jindan, your method only works if every column is the same width. Glad I caught that before running it, because mine aren't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks