Skip to main content

Borders.ThemeColor property

Table of contents
  1. Syntax
  2. Remarks
  3. Examples

Returns or sets the theme color in the applied color scheme that is associated with the specified object. Read/write Variant.



expression A variable that represents a Borders object.


Attempting to access a theme color for an object whose color is not currently themed will result in an invalid request run-time error.


The following example sets the borders color of the range B2:E5 to 9 (theme color, blue).

ActiveSheet.Range("B2:E5").Borders.ThemeColor = 9

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>