Changing width of a column

Hello All,

The command I got by recording a macro to change a column's width is

Please Login or Register  to view this content.

In my case, I copy data from different workbooks in a folder and in different cases, different number of columns will be filled and I would like to change width of all the columns in the new workbook, that are eventually filled up (starting from Column D). is it possible to do it using a macro, may be by writing some command in the loop structure that changes the width after the column is filled.

This loop copies data from different files (in a folder) to the present workbook, so may be it can also change the width for the columns after it pastes the data to it.

Thank you and regards
arora

Please use Code Tags, even for single lines of code.

Why not use

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.