View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Katherine R Katherine R is offline
external usenet poster
 
Posts: 5
Default Insert / Name / Define

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.