View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Martin[_2_] Paul Martin[_2_] is offline
external usenet poster
 
Posts: 133
Default Moving a local name to another sheet

In code, I'm rebuilding various sheets in a workbook by cutting and
pasting the contents of a sheet to a new one, but the local names on a
sheet remain attached to the old sheet (which I want to delete). Is
there a way to make the name attach to the new sheet without looping
through all the names and find the local names?

Thanks in advance

Paul Martin
Melbourne Australia