View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default remove all format(s) on a sheet

ActiveSheet.Cells.ClearFormats


"Vsn" <vsn_hotmail_kom wrote in message
...
Hi all,

Is the a way in with VBA code to remove ALL formats from a sheet,
including lines, width, text bold, etc., and set all back to default.

This would be very helpfull to me.

Thanks,
Ludovic