View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Yngve Yngve is offline
external usenet poster
 
Posts: 67
Default ClearContents on 1st sheet from 2nd sheet

Hi Robert

Try this

Range("TransStatement").ClearContents

Regards Yngve