| {\rtf1\ansi\ansicpg1252\deff0\deflang1044{\fonttbl{\f0\fnil\fcharset0 MS Sans Serif;}} \viewkind4\uc1\pard\f0\fs17 Description:When importing data from Access your rows and columns get goofed up and your data doesn't look easy to read. This little piece of simple code makes everything format real quick. Add this code to a button for a fast click. \par Assumes:Add to your Personal.xls macro sheet to use anytime. Attache the code to a button for a fast format or autofit columns & rows. \par \par \par Sub AutoFitRows() \par Cells.Select \par Selection.ColumnWidth = 100 \par Selection.Rows.AutoFit \par Selection.Columns.AutoFit \par Selection.ColumnWidth = 8.43 \par Selection.Columns.AutoFit \par Range("A1").Select \par End Sub \par } |
Autofit Data Simple Code |
India web developer web development India | India web development company India ecommerce web developer