Vba script to clear all formatting
This VBA script quickly removes all formatting from the active Excel worksheet, leaving all cells formatted as TEXT.
Included is also a quick guide how to run this script - no prior coding knowledge required.
The script is very handy for cleaning up imported .csv and other types of delimited flat files. It also sets the proper column width so you can see all the data properly.
Opposed to other free codes out there which do something similar, this is a complete and structured solution. It is also editable.
License: This script is only for own, personal use. If you use it in an Excel sheet, please don't share the Excel file before removing the script.
If, despite the self-explanatory guide, you are struggling to make this script work we're happy to have a look at what the issue is. If it doesn't work for any reason (and we cannot fix it), you'll get a full refund.