Insert / Name / Define
Your code?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Katherine R" wrote in message ...
|I have a macro that should delete the contents of a named range, but it's not
| deleting cell H17. In the Refers to box the range is defined as
| ='Sheet1'$H$10:$H$17. H10 through H16 deletes, but I have to manually delete
| H17. What goes here?
|
| Thanks.
|