Thread: VBA killing my named ranges
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Daniel.M Daniel.M is offline
external usenet poster
  
Posts: 32
Default VBA killing my named ranges
Hi Jon,

You're clearing the E6 in your macro (with the delete command).

Use Range(Cells(6, 4), Cells(inrow, 12)).ClearContents ' instead

Regards,

Daniel M.


Reply With QuoteReply With Quote