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

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

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 01:20 AM.