Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user defined functions format | Excel Discussion (Misc queries) | |||
all user defined cell format del using macro | Excel Programming | |||
Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming |