Get Cells Formats

[abaca]

Hi there!
How do I get all selected formats for a cell?

Cells
.ColorIndex, .Brave, .Combined, .Borders, .Italic, .Font Size / Name, etc.



Thank you.

 

[HackSlash]

Depends on what you mean by "get"

The method you are talking about is using the "range object"

Declare your range object like this:

Dim example As Range
  Set example = Range("A1")

Now you can use those formats like this:

example.ColorIndex, example.Brave, example.Combined, example.Borders, example.Italic, example.Font Size / Name, etc.