What's the RIGHT way to reference named cells

Question

I have a cell (Ok there's a bunch but I'm just looking at one now) named "Classes". It's "C10" by Excel's grid notation.

My code works perfectly when I reference the cell as

Range("C10") = "Value"

But when I use

Classes = "Value"

It just does nothing.

So, what's the correct way to reference a named cell by its name?

Answer 1

You replace the address with the named range's name:

Range("Classes") = "Value"

Answer 2

You can use the square bracket shorthand for referencing ranges:

[Classes] = "Value"

So you can save on Range and "", and it also looks better (square brackets look a bit like a cell). You can also use [C10] = "Value"