set column width

[virgil]

I am completely new to some of this and am lost as to how to set column widths in excel using a macro. My problem is I don't have any experience with this process. What I need is a macro that lets me set different widths for seven columns on a csv worksheet I have. Any and all help will be greatly appreciated.

 

[repairman615]

Hello,
Welcome to the Message Board!!

Here is a sample from the macro recorder:

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Macro1()<br><SPAN style="color:#007F00">'</SPAN><br><SPAN style="color:#007F00">' Macro1 Macro</SPAN><br><SPAN style="color:#007F00">'</SPAN><br><br><SPAN style="color:#007F00">'</SPAN><br>    Columns("A:A").ColumnWidth = 34.71<br>    Columns("B:B").ColumnWidth = 16.57<br>    Columns("C:C").ColumnWidth = 23.71<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[Ruddles]

And here's another:-

Sub Macro1()
[COLOR=green]'
' Macro1 Macro
'[/COLOR]
[COLOR=green]'
[/COLOR]    Columns("E:E").EntireColumn.AutoFit
End Sub

You know that column widths aren't saved with a CSV file, yes? Next time you open it, the column widths will all be set to default.

 

[virgil]

Many thanks for the reply, but I still can't get it to work. I may not be saving the macro properly or something. I will continue to resize while working on the spreadsheet. Maybe one of these days I will figure it out.

 

[Ruddles]

Are you saving it as a CSV?

 

[virgil]

Hi,
Sorry about the delay in responding to your post but have been out of pocket a few days. I was saving it as a macro in the workbook but it would not save for some reason. I finally went to the record macro feature and finally got it to save in the personal.xlsb file. Now I just use the hot key I set up and the columns auto resize.

Again, many thanks and I will probably be needing assistance in the future.

Virgil