Thread
:
VBA Change Format of All Cells in a Workbook
View Single Post
#
2
Posted to microsoft.public.excel.programming
JE McGimpsey
external usenet poster
Posts: 4,624
VBA Change Format of All Cells in a Workbook
One way:
Dim ws As Worksheet
For Each ws in ActiveWorkbook.Worksheets
ws.Cells.NumberFormat = "General" ' or "@" for Text
Next ws
In article
,
wrote:
With VBA I would like to change the format of all cells in all
worksheets of a workbook to 'General' or 'Text'. How can this be
done? Thanks.
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey