how do i do using macro for deleting all user defined cell format in a
specific workbook?
sub()
~~~~~~~
end sub
*** Sent via Developersdex http://www.developersdex.com ***
how do i do using macro for deleting all user defined cell format in a
specific workbook?
sub()
~~~~~~~
end sub
*** Sent via Developersdex http://www.developersdex.com ***
Hello x toal,
Here is the macro...
Public Sub ClearAllFormats()
Dim Wks
For Each Wks In ActiveWorkbook.Worksheets
Wks.UsedRange.ClearFormats
Next Wks
End Sub
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks