Microsoft Office Forums - View Single Post - [Solved] Column padding not taking

Thread: [Solved] Column padding not taking

View Single Post

Old

12-20-2024, 11:49 AM

DavidPaul

DavidPaul is offline

DavidPaul uses Windows 11

Windows 11 DavidPaul uses Office 2013

DavidPaul uses Office 2013

Office 2013

Novice

The original poster

Join Date: Oct 2023

Posts: 9

DavidPaul is on a distinguished road

Default

Column padding not taking

I have a macro that resizes all column of a certain colour, which includes this code:

Code:

thisCol.LeftPadding = CentimetersToPoints(0.1)
thisCol.RightPadding = CentimetersToPoints(0.1)

However, if I manually drag-and-widen a column, then run the macro, it doesn't work. The padding remains unchanged. Any ideas?

Reply With Quote