Adjust Two Columns Without Changing Combined Size

BobBridges · #1 04-11-2020, 08:13 AM

Only way I can think of is to write a VBA program; it'll look at the widths of cols B and C and adjust them appropriately. You can run it periodically and manually, or maybe have it run automatically whenever you make any change to the worksheet—which way is better depends, I suppose, on how much work you do with that worksheet and what kind of changes. I'd say start it as a program you trigger manually, and decide later whether you want to turn t loose to be triggered by changes.

If you don't know how to create such a program, one of us can help, I'm sure :-).

beno_83au · #2 04-11-2020, 08:27 PM

Quote:

Originally Posted by BobBridges

Only way I can think of is to write a VBA program

Cheers Bob. Looks like I might be able to create a macro for this at a quick glance, so we'll see how far I get with that.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Adjust Every Header Section Size at Once?	CrossReach	Word	4	03-13-2016 10:49 AM
How do I adjust the size of the printed slide	Suppy	PowerPoint	2	01-27-2015 02:15 AM
How to adjust Image size and other question	arjfca	Word VBA	1	12-05-2014 02:00 AM
Powerpoint 2013 doesn't adjust size on external display	mejnik	PowerPoint	1	04-04-2014 09:12 AM
Adjust Window size at open	Gary Drumm	Windows	2	03-31-2014 08:22 AM