how to select and name a range in excel

Macro 34: Select and Format All Named Ranges If you spend your time auditing other people’s worksheets, you’ll know that Excel users love their named ranges. It’s not uncommon to encounter spreadsheets where dozens of cells and ranges are given individual names. This makes auditing a spreadsheet an extremely muddy experience. It some- times helps […]