CODEWITHSUNDEEP
vbaexcelexcel-2013
StolenKitten
StolenKitten

Reputation: 651

What's the RIGHT way to reference named cells in Excel 2013 VBA? (I know I'm messing this up)

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?

Upvotes: 19

Views: 78311

Answers (2)

robotik
robotik

Reputation: 2007

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"

Upvotes: 27

Jon Crowell
Jon Crowell

Reputation: 22320

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

Range("Classes") = "Value"

Upvotes: 36

Related Questions