selection.columnwidth

I was able to create this Macro with the help of @Logit in this section ' Create the Concatenate Formula and Autofill Formula to the Last Row with Data the concatenate works but it goes down to row 10,000 and I would like the macro to stop the concatenate formula when the cell on the right...

I am trying to create a Macro that formats each column to a particular width. But, when I run the Macro, it just sets all the columns' width to 1. Where am I going wrong? Sub Macro4()' ' Macro4 Macro ' ' Selection.ColumnWidth = 1 Columns("B:B").Select Range("B2").Activate...

Hi All, I'm working with this code to make all worksheets of a workbook with columns A, B & C a specific size. Sub ColumnPrep() ' Dim wks As Worksheet Application.ScreenUpdating = False For Each wks In Worksheets wks.Activate Range("A:A").Activate...

I don't get why this is not working, but I am trying to clean up and speed up my code. I currently have this and it works fine within my sub. Columns("O:Q").Select Selection.ColumnWidth = 35.01 Columns("A").Select Selection.ColumnWidth = 6.01 Columns("B").Select...

I currently have a sub in my workbook, that sorts some data, then creates tabs based on a range and the Array argument. The problem I see is when I leave or for someone without experience in VBA would need to add or delete some of the Array arguments. I want to get rid of the code, and...