SpreadsheetWEB
  • Home
  • Pricing
    • Cloud Pricing
    • Server Pricing
  • Applications
    • By Industry
      • Education
      • Insurance
      • Investment
      • Public Sector
      • Startups
    • By Department
      • Finance
      • Human Resources
      • IT
      • Sales
    • By Type
      • Data Collection
      • Data Visualization
      • Online Calculators
      • Online Reports
      • Mobile Applications
  • Services
  • Resources
    • Blog
    • Case Studies
    • Data Sheets
    • Demos
    • FAQ
    • Resources
    • Tutorials
    • User Guide
    • Video Tutorials
    • Whitepapers
  • About
    • About Us
    • Contact Us
    • Customers
    • Press Releases
  • Try for Free
Select Page
How to get the worksheet name, workbook name, and its path

How to get the worksheet name, workbook name, and its path

by Ilker | Apr 6, 2018 | Excel Tips & Tricks

Working across several workbooks with multiple sheets can be tedious. Furthermore, file names are dynamic and can be changed by your users. Use this simple trick to organize your data and label workbook details. Syntax =CELL(“filename”, reference which is...

Recent Posts

  • Forecasting in Excel
  • How to make Excel change case to uppercase using VBA
  • How to have Excel convert formula to value using VBA
  • How to delete all named ranges with #REF Excel errors using VBA
  • All You Need to Know for Using Excel Iterative Calculation
  • How to find named ranges in Excel by highlighting them using VBA
  • How to lock a cell in Excel formula using VBA
  • How and Why of Running a Simulation in Excel
  • How to un-protect a protected worksheet and vice versa – the VBA method
  • How to alphabetize Excel tabs using VBA
  • Facebook
  • Twitter
  • Linkedin

© 2018 Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use