Remove Formatting

  • Thread starter Thread starter ddpcad
  • Start date Start date
D

ddpcad

Hi All,
I've received an .xls file from a customer that contains a generous
amount of formatting. I use a 3rd party program to link spreadsheets to
AutoCAD drawing files (.dwg) but it chokes on this particular
spreadsheet I assume due to all of the formatting. Is there a way to
remove all formatting from a spreadsheet and maintain all of the data?
Dave
DDP
 
UN tested but try this
sub df()
Application.Cells.FormatConditions.Delete
end sub

Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
 
Back
Top