Can you please use codetags !!
Code:Sheets("SEGREGATION").usedrange.ClearContents Sheets("UNCLASSIFIED").Range("A13").ClearContents intersect(Sheets("CLASSIFIED").usedrange,range("A:C,K:W").Offset(1, 0).ClearContents
Can you please use codetags !!
Code:Sheets("SEGREGATION").usedrange.ClearContents Sheets("UNCLASSIFIED").Range("A13").ClearContents intersect(Sheets("CLASSIFIED").usedrange,range("A:C,K:W").Offset(1, 0).ClearContents
Bookmarks