i want to multiply range "A2:A6" with range "B2:B6 and out put range in "C2:C6 but condition is only enter a value in range "A2:A6 and "B2":B6 then out put show in range "C2:C6" otherwise contents clear in range C2:C6 by this selection change event by macro only more clarification is enter value "A2" and "B2" then out put show "C2" . i upload file