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

vba excel excel-2013
StolenKitten picture StolenKitten · Jun 21, 2013 · Viewed 72.8k times · Source

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

Jon Crowell picture Jon Crowell · Jun 21, 2013

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

Range("Classes") = "Value"

Related questions

Clear contents and formatting of an Excel cell with a single command

If you want to clear the contents of a cell or range in Microsoft Excel, you can use .ClearContents. If you also want to clear the formatting, you can use .ClearFormats. Sheets("Test").Range("A1:C3").ClearContents Sheets("Test").Range("…

Read More
Remove Duplicates from range of cells in excel vba

I'm trying to remove duplicates in excel 2013 VBA. but I'm getting error "object does not support this property or method". The problem is I don't have static range to select. I want remove duplicates from the column heaader 'abcd'. Cells.…

Read More
No Add-In Tab Though Add-In is Loaded and Working

I wrote an Excel VBA add-in over ten years ago, which uses the old Commandbars to put a menu in Excel's Tools menu (in Excel 2003 and earlier) or in Excel's Add-Ins tab (in Excel 2007 and later). I've never had a …

Read More