BruceEdwards
Board Regular
- Joined
- May 28, 2004
- Messages
- 231
I have been using AUTOFIT to set the column width, using VBA. However, I don't quite like the look that Autofit gives, I would like the columns to be slightly wider, maybe 2 or 3 spaces.
Is there any way to do this in VBA? I cannot figure out how to do it.
Essentially, what I am thinking is that the macro would specify Autofit, then somehow, go back and increase column width by a factor of say, 3 spaces. So the final width would be "Autofit + 2 "
Another possibility I thought of was if a macro could be written to count the number of characters in the widest cell in a column, then increase by a factor.
Any ideas??
Is there any way to do this in VBA? I cannot figure out how to do it.
Essentially, what I am thinking is that the macro would specify Autofit, then somehow, go back and increase column width by a factor of say, 3 spaces. So the final width would be "Autofit + 2 "
Another possibility I thought of was if a macro could be written to count the number of characters in the widest cell in a column, then increase by a factor.
Any ideas??