Autofit Column w/ extra spaces

Marc · Mar 7th, 2002, 11:09 AM

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 · Mar 7th, 2002, 11:44 AM

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 · Mar 7th, 2002, 12:25 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 11:09 AM	#1
Marc Board Regular Join Date: Feb 2002 Posts: 383	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

Mar 7th, 2002, 11:44 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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

Mar 7th, 2002, 12:25 PM	#3
Marc Board Regular Join Date: Feb 2002 Posts: 383	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