Excel Titan

Knowledge should be shared freely, not hoarded.

Function To Get The Selected Sheet Names With Examples

3 minute read

Function to get the selected sheet names with examples.

less than 1 minute read

Function to check if multiple named ranges exist

1 minute read

When you want to just show numbers as 9.1 M or 830 K

less than 1 minute read

Forces the SaveAs UI to only accept a XLSM Macro-Enabled Workbook.

1 minute read

Examples on how to first the last row, first available blank row or the last blank row