View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ragtopcaddy
 
Posts: n/a
Default Remove all formatting


I'm looking for a method to remove all formatting from selected ranges.
The goal would be to revert to the default cell format for the selected
range.
Is there a function in Excel to do that, or can you recommend some VBA
to add a custom function?

Thanks,

Bill


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=517294