Range("B1:IV65536").Delete _____该语句能“删除”A列以外的数据“清除”A2,B3,D4 "单元格" 以外的其他单元格信息(包含数据,公式,格式....):DIM MYRANGE AS RANGESET MYRANGE = RANGE("A2","B3","D4")MYRANGE.CLEARSET MYRANGE =NOTHING
Range("B1:IV65536").SelectSelection.Delete