View Single Post
 
Old 07-17-2024, 09:21 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Select the range you want to process A6:L1130, then in name box here, type the name (if the name doesn't already exist you'll see the cell address A6, which you overwrite):

2024-07-17_170309.jpg

2024-07-17_170543.jpg

Changing its extent is a bit different if it already exists. You can go into Name Manager on the Formulas tab of the ribbon:

2024-07-17_170752.jpg
and either delete it in the dialogue box, then go back into the sheet and recreate it as before,
or
you can edit it directly in the dialogue box:

2024-07-17_171543.jpg
Reply With Quote