Excel tab sheet names vs. Visual Basic sheet names

by

In the Excel object model a Worksheet has 2 different name properties:

Worksheet.Name
Worksheet.CodeName

the Name property is read/write and contains the name that appears on the sheet tab. It is user and VBA changeable

the CodeName property is read-only

You can reference a particular sheet as
Worksheets(“Fred”).Range(“A1”) where Fred is the .Name property
or as
Sheet1.Range(“A1”) where Sheet1 is the codename of the worksheet.

More Related Contents:

  1. Refer to sheet using codename
  2. Query my excel worksheet with VBA
  3. delete Autofilter Field resullt using the header Name
  4. Somehow it’s not copying [closed]
  5. VBA macro that search for file in multiple subfolders
  6. So, I have 6 “master” files to then divide into 40 separate files
  7. Getting ScriptControl to work with Excel 2010 x64
  8. Application.Match gives type mismatch
  9. Count and Highlight keywords within phrases
  10. Transpose a range in VBA
  11. Protecting cells in Excel but allow these to be modified by VBA script
  12. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  13. How to add a named sheet at the end of all Excel sheets?
  14. Detect merged cells in VBA Excel with MergeArea
  15. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  16. VBA Macro to compare all cells of two Excel files
  17. Excel VBA – QueryTable AfterRefresh function not being called after Refresh completes
  18. Excel VBA: AutoFill Multiple Cells with Formulas
  19. VBA.Find and adding a value
  20. excel vba- extract text between 2 characters
  21. Round function in Excel, worksheet function vs VBA
  22. How to continue the code on the next line in VBA
  23. Excel VBA Userform – Execute Sub when something changes
  24. Count the number of rows in another sheet [duplicate]
  25. Getting Excel to refresh data on sheet from within VBA
  26. VBA Password Input with Cancel Function
  27. Finding first blank row, then writing to it
  28. Reducing WithEvent declarations and subs with VBA and ActiveX
  29. How do I get a list of unique values from a range in Excel VBA?
  30. How to get selected value in multicolumn listbox

Leave a Comment