Excel / VBA: auto-adjust column width after pasting data

excel vba column-width
user2571510 picture user2571510 · Jun 5, 2014 · Viewed 71.4k times · Source

I have a blank Excel table saved as a template into which I copy data from the clipboard (originating from a website).

Is there a way using VBA to auto-adjust the width of each column to its content after the data (text) has been pasted in ?

Edit: The data I paste will always be inserted starting from A1 and will always fill the same number of columns.

Answer

InformatikBabo picture InformatikBabo · Jun 5, 2014

You can do it with AutoFit:

 Columns("A:B").EntireColumn.AutoFit

Related questions

How to auto-size column-width in Excel during text entry

I usually try to avoid VBA in Excel, but it would be convenient to be able to type text into a cell, and have its column get wider or narrower to accommodate the text remaining as it's entered or deleted. …

Read More
How to detect values that do not fit in Excel cells, using VBA?

We are generating long Excel sheets using various tools, which have to be reviewed and used as input further down in the workflow. The problem that some cells are too small for texts they contain. So humans and programs that …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More