Thread: Run-time error "5" after range().delete runs before querytable.add
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default Run-time error "5" after range().delete runs before querytable.add

Try clearing the range rather than deleting it.
Selection.Clear

Reply With QuoteReply With Quote