Excel Macro Causing the Formatting to change to Default

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Excel Macro Causing the Formatting to change to Default

03-29-2015, 05:21 PM

ubns

Windows 7 32bit Excel Macro Causing the Formatting to change to Default

Office 2010 32bit

Competent Performer

Join Date: Apr 2012

Posts: 177

AutoFit Function is the below. What can I change in this so that it does not change to default formatting.

Code:

Public Sub AutofitRows()
    Dim rng As Range
    Set rng = ThisWorkbook.Worksheets("projectandbau").Rows("1:5000")
    rng.Autofit
       
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using VBA to change styles causing TabStop problem	rjrichar40	Word VBA	2	08-12-2014 10:35 AM
Change Default Excel Grid to Solid Black Lines	SQLUSA	Word	1	07-15-2012 10:04 PM
Importing Styles causing odd formatting problems.	Red Pill	Word	3	06-12-2012 06:19 AM
How do I change default	cinque8	Word	5	06-08-2012 11:18 AM
How do I change default log-in info?	RainPure	Office	0	11-15-2010 05:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:53 AM.