Excel Column Width macro issue

[algrey7]

Hi hoping someone can help please?

I am trying to use this code to adjust certain columns to certain widths -

Sub Columns()
'
' Columns Macro
'

'
Columns("A:A").Select
Selection.ColumnWidth = 72.29
Columns("B:D").Select
Selection.ColumnWidth = 26.71
End Sub

But get the following error -

Any ideas what I am missing please?

 

[rpaulson]

Columns("A:A").ColumnWidth = 72.29
Columns("B:D").ColumnWidth = 26.71

 

[Joe4]

Try changing the name of your procedures from "Columns" to something like "MyColumns".

You should NEVER use reserved words like "Columns" as the names of your procedures or variables (reserved words are the names of existing out-of-the-box functions, properties, methods, objects, etc). Doing so can cause errors and unexpected results.

 

[algrey7]

Columns("A:A").ColumnWidth = 72.29
Columns("B:D").ColumnWidth = 26.71

Thank you so much!

 

[algrey7]

Try changing the name of your procedures from "Columns" to something like "MyColumns".

You should NEVER use reserved words like "Columns" as the names of your procedures or variables (reserved words are the names of existing out-of-the-box functions, properties, methods, objects, etc). Doing so can cause errors and unexpected results.

Thank you so much!

 

[Joe4]

You are welcome.
Glad we could help!