VBA Set the Format of Columns A and B to "General"

[Dannottheman]

Good morning,

I searched for this and could not find it. Does anyone know of a VBA to set the content/cells in both columns A and B to "general". I know I can do this manually, but I have several tasks that will run via a VBA and I prefer to add this to the existing VBA rather than to manually have to do it as I have a couple of hundred files to do.

 

[Fluff]

How about

   Columns("A:B").NumberFormat = "General"

 

[Rick Rothstein]

Columns("A:B").NumberFormat = "General"

which can also be written this way...

[A:B].NumberFormat = "General"

 

[Dannottheman]

Thank you. Is there anything else I need to it for the VBA to work, or literally it's just inputting this in the VBA module: [A:B].NumberFormat = "General"

 

[Fluff]

Just add that line to your existing code.

 

[Dannottheman]

Sorry, this is my existing code. Where exactly can it be added:

Sub Test()

Application.ScreenUpdating = False

With ActiveSheet.Columns("A")

.ColumnWidth = 95

.WrapText = True

End With

Application.ScreenUpdating = True

End Sub

 

[Fluff]

Probably doesn't matter, but try putting it after the End With line

 

[Dannottheman]

Worked! Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.