560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
The hidden door to extra functions in Excel
Part five of a six-part series of blogs
Did you know that you could combine range names and legacy Excel 4 functions to list out the worksheets or range names in your workbook - wthout using macros? I didn't either - here's how to do this, and much more!
Below are some of the other ideas I could come up with - see how many more you can think of!
To list out the range names in a workbook, first create a range name using the Names() function:
This range name will return a list of the range names in this workbook.
Then use this, transposing the results:
The list of range names in the current workbook.
You could even use an additional argument to the Names() function to apply a wildcard filter (for example to show all of the range names containing the letters owl).
You could use the Get.Document function to get the row and column number of the last active cell in a worksheet. First create a range name for the last row, using the argument 10:
See the last blog in this series for how to find out the argument numbers and function names that you can use.
Then do the same for the last active column:
This range name gives the last active column, using the argument 12.
You can now put these together to get the cell reference of the last active cell:
Get the address of the cell with the given row and column number (the argument 4 returns it as a relative reference, not an absolute one).
|Parts of this blog|
Some other pages relevant to the above blogs include:
25 Aytoun Street