![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/different-ranges.png\")
<\/figure>\n\n\n\nAs seen, all three ranges presented in the picture above are basically the same. The only difference is noticeable in range number 3<\/strong>, where we have one comment (marked in Excel with a purple triangle in the upper right corner of the cell).<\/p>\n\n\n\n For the first thing, we will erase the range number one and will clear all the formats as well: bolded cells, Range 1<\/strong> word is merged and centered and in yellow.<\/p>\n\n\n\n To do this, we need to go to the VBA editor<\/strong>. In order to do so, we press ALT + F11<\/strong> on our keyboard. After that, on the window that appears, we will right-click on the left window and choose Insert >> Module<\/strong>:<\/p>\n\n\n\n Once clicked, we will be presented with the clear text field, in which we will insert the first code:<\/p>\n\n\n\n This is what our code looks like in the editor:<\/p>\n\n\n\n When we execute our code by pressing F5<\/strong> on our keyboard, we will notice that the range A1:C7<\/strong> will be completely erased and that the format will be erased as well: no bold, and cells A1:C3 are not merged and centered<\/strong> as well:<\/p>\n\n\n\n For the next thing, we will clear the content of range 2<\/strong> but will keep the formats of these cells. To do so, we will write the following code:<\/p>\n\n\n\n This is what our code looks like in the editor:<\/p>\n\n\n\n When we execute this code, we will notice that only the numbers and text were cleared, but not the formatting itself:<\/p>\n\n\n\n We can notice that cell E1<\/strong> is still merged and centered and that cells E1:G1<\/strong> are bolded and colored in orange.<\/strong><\/p>\n\n\n\n So the option ClearContents<\/strong> simply erases only the content itself, but not the formatting.<\/p>\n\n\n\n The easiest way in which you could find out about all the clearing options in the VBA, is to press CTRL + SPACE<\/strong> right after we define our range and we insert a dot:<\/p>\n\n\n\n With this, we will be able to see IntelliSense<\/strong>. This is a great way in which VBA can complete our sentences, and we can scroll down to see all the options available. Once we get to the Clear option<\/strong>, we will see other options at our disposal. For this exercise, we will show ClearComments<\/strong> as well, so we will choose that one for range 3<\/strong>:<\/p>\n\n\n\n And in the editor:<\/p>\n\n\n\n When we execute this code, we will notice that the comments have been cleared from Range 3<\/strong>:<\/p>\n\n\n\n And we no longer have a purple triangle appearing in the upper right corner, which is exactly what this code was supposed to do.<\/p>\n","protected":false},"excerpt":{"rendered":" With VBA, you can always create a code that will automatically do certain actions, write something in your sheet, create another sheet or…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"yoast_head":"\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/inserting-module-3.png\")
<\/figure>\n\n\n\nSub Range1_Cleared()\n Range(\"A1:C7\").Clear\nEnd Sub<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/clearing-range-code.png\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/code-executed.png\")
<\/figure>\n\n\n\nSub Range2_Cleared()\n Range(\"E1:G7\").ClearContents\nEnd Sub<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/clearing-range-content-code.png\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/code-executed-2.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/clearing-options.png\"){kind=spacer}
<\/figure>\n\n\n\nSub Range3_Cleared()\n Range(\"I1:K7\").ClearComments\nEnd Sub<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/clearing-range-comments-code.png\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/comments-cleared.png\"){kind=spacer}
<\/figure>\n\n\n\n