In this article I will explain how you can removeborders from a range of cells. Removingborders is similar to creating borders. All you have to do is set the .LineStyle property to xlNone. For more information about creating borders please see Excel VBA, Create Border.
In this article I will assume we have the following borders in the range B2:H11. Each section will explain how you can remove the border from one of the edges: