Autofit Column w/ extra spaces

[Marc]

I have data in columns that I sum at the bottom of the sheet via a macro. The macro also performs an autofit upon the column. This leaves my column totals right up against each other. The data values fluctuate in size so I don't want to use a fixed column size. Is there a way to perform the autofit and add a few spaces before the sum so that there is a report that is better on the eyes. Thanks, Marc

 

[dk]

Why don't you use the Autofit method after you've done the sum bit e.g.

Range("A1:A10").Formula = "=INT(rand()*1000000000)"
Range("A11").Formula = "=SUM(A1:A10)"
Cells.Columns.AutoFit

HTH,
D

 

[Marc]

I already have the autofit method in place, what I need is to add two character spaces to each column so to give more room between the dollar totals. Thanks, Marc