thomas.szwed
08-07-2008, 03:17 AM
hi there,
could anyone tell me some VB to do the following automatically when the workbook is opened.
In Workbook on ALL sheets
Format all cells in columns E F and J into 'Text' format.
I have this so far but unsure how to modify
With ThisWorkbook.Worksheets(1)
.Columns("J").NumberFormat = "dd/mm/yyyy"
End With
Thanks in advance!
could anyone tell me some VB to do the following automatically when the workbook is opened.
In Workbook on ALL sheets
Format all cells in columns E F and J into 'Text' format.
I have this so far but unsure how to modify
With ThisWorkbook.Worksheets(1)
.Columns("J").NumberFormat = "dd/mm/yyyy"
End With
Thanks in advance!