Range("BE[SIZE=5][COLOR=Red]1[/COLOR][/SIZE]:BJ" & 42 + z).ClearContents
Range("BE:BJ" & 42 + z).ClearContents
Range("BE42:BJ" & 42 + z).ClearContents
Range("BE" & 42 + z:"BJ" & 42 + z).ClearContents
Range("BE" & 42 + z & [COLOR="Red"]":[/COLOR]BJ" & 42 + z).ClearContents
Range("BE" & 42 + z & ":BJ" & 42 + z).ClearContents