all user defined cell format del using macro
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 *** |
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 |
All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com