This simple script:
? does not work ? the table is created, but after then the following error occurs in width changing line:
Please Login or Register to view this content.
Please let me know how I can change cells width (it will be different for different cells).Run-time error '4608'
Value out of range
Thank you!
Your code works (for me anyway) if you increase the value of your cellWidth variable to anything 3.9 or above.
BSB
But I can easily set cell width to 0.35 cm and even less, manually in the table that the script creates, later. Why is that I can’t do it in the script, I can not understand.
The whole point of the script is to set cell width programmatically, since there will be a lot of cells in the table 😀.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I have then attached a word file with this macro to the post.
I thought it would be easier just to copy the code from the start topic into Visual Basic Editor.
Sample.docm
For me neither 3.9 nor 4.35 work as well.Originally Posted by BadlySpelledBuoy
Here's something to play with.
Everything works until v3. The first cell fails, the rest are ok. Presumably 0.4 is the lowest limit.
Same scenario with v4. The first row fails, the rest are ok. Same conclusion.
Output:Please Login or Register to view this content.
PHP Code:1.1
1.2
1.3
1.4
1.5
2.1
2.2
2.3
2.4
2.5
3.1
3.2
3.3
3.4
3.5
0.55
0.6
0.65
0.7
0.75
1.05
1.1
1.15
1.2
1.25
1.55
1.6
1.65
1.7
1.75
0.366666666666667
0.366666666666667 failed
0.4
0.433333333333333
0.466666666666667
0.5
0.7
0.733333333333333
0.766666666666667
0.8
0.833333333333333
1.03333333333333
1.06666666666667
1.1
1.13333333333333
1.16666666666667
0.275
0.275 failed
0.3
0.3 failed
0.325
0.325 failed
0.35
0.35 failed
0.375
0.375 failed
0.525
0.55
0.575
0.6
0.625
0.775
0.8
0.825
0.85
0.875
Last edited by TMS; 08-06-2023 at 08:21 PM.
You might need to change the left and right margins from the defaults. The Cell Margins button is in the Alignment group on the Layout tab, I think (can't check at the moment).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks