Excel Vba Clear Sheet Contents And Formatting. Press the alt + f11 keys to open the microsoft visual basic for applications window. To clear cell contents (but not formatting) using vba, use a statement with the following structure:
No matter which method is used, the result will return true if you use isempty () function on the cell. We specify that that only worksheets 1 and 2 are to be cleared. This will open the visual basic editor.