(name) v "name" property

  1. S

    Accessing name property of ActiveWorksheet

    Hi All Possibly a very simple question. In VB when I select a worksheet, I can amend the (Name) of the worksheet in the properties window. There is also the .Name property which is the same as the sheet tag name. I can use the (Name) in vb code to identify the sheet e.g...
  2. R

    Use of worksheets codename

    Can the codename property (Name) of a worksheet be used in an excel formula? If so, what is the correct syntax?
  3. R

    (Name) vs. "Name"

    Is there a way to refer to a worksheet in a formula by its (name) as opposed to its "name", (name) being what is shown as the sheet's first property in the properties window? Or maybe a function?

Some videos you may like

This Week's Hot Topics