HomeServicesBusiness and Systems AnalysisExcel analysis, design and buildCalculation and model designSolution realisationPension specialistsTechnologyExcel and VBA trainingContactBlog
​
Specialists in the analysis, design, build and testing of financial, engineering and mathematical spreadsheets, tools and websites.

RPM IT Consulting

RPM IT ​Consulting

Rob's Blog

  1. Excel Tricks - Part 4 : GetNames - Getting a list of named ranges
    23
    Sep

    Excel Tricks - Part 4 : GetNames - Getting a list of named ranges

    Welcome to RPM IT Consulting's Excel hints and tips blog - over the next few months we will be adding to our Excel Tricks blog with some useful hints and tips.  Some you will know. some you wont, some you may have forgotten, some may be useful and some will be for  fun!    GetNames This VBA code can be used to find and list all the named ranges/cells and their names in a workbook. The named ranges are then displayed to the user in a new sheet. ‘This does this by inserting a new sheet and then
RPM IT Consulting specialise in the analysis, design, build and testing of engineering, financial and mathematical spreadsheets, tools and websites.

FEATURED POSTS

  1. Using (pseudo) N-Tier Architecture in Excel

    11/03/2016
  2. Excel Tricks - ReverseChar - Convert a character to its ASCII number

    10/03/2016
  3. Excel Tricks - Welcome! Getting usernames using VBA

    02/06/2016

TAGS

  1. @rpmit
    5
  2. excel
    5
  3. hint
    5
  4. microsoft
    5
  5. rpm it consulting
    5
  6. spreadsheet
    5
  7. tip
    5
  8. tricks
    5
  9. vba
    5
  10. getapplicationuser
    1
  11. getwindowsuser
    1
  12. eval
    1
  13. evaluate
    1
  14. agile
    1
  15. business analysis
    1
  16. devops
    1
  17. lord kelvin
    1
  18. quote
    1
  19. ascii
    1
  20. char()
    1
  21. getnames
    1
  22. named range
    1
  23. architecure
    1
  24. design
    1
  25. multi-layer
    1
  26. multitier
    1
  27. mvc
    1
  28. n-tier
    1

    RPM IT Consulting

    ​Copyright All Rights Reserved RPM IT Consulting Ltd 2019, Terms and Conditions