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

vba excel excel-2013

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

Range("Classes") = "Value"

vba excel excel-2013

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"

CodeHunter