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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidden Formating Or Delimiters: Showing Of ? 2
.csv Format Questions 1
Excel Macro to Open and Print Multiple PDF Files 6
ReImport text data and keep existing formatting 1
Toolbars change for no apparent reason 4
Formatting number in Data Table 2
Remove date format? 3
Excel 2007 Saving Cell types in XLS format 1

Back
Top