Tuesday 15 March 2011

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


I have a cell (well, there's a bunch, but I'm just looking at just one) name "classes " is. This is "C10" by Excel's grid notation

range ("C10") = "value"

but when reference to my code cell

Then if I use class = "value"

it does not do anything only

What is the correct way of referring a designated cell to its name?

You replace the address with the named category name: 

  Range ("Classes") = "Value"
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)