Thread: all user defined cell format del using macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_331_] Leith Ross[_331_] is offline
external usenet poster
  
Posts: 1
Default all user defined cell format del using macro

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 Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48806

Reply With QuoteReply With Quote