If Sheet1.Range <> “” And Sheet1.Range <> “” And Sheet1.Range <> “” And Sheet1.Range <> “” And Sheet1.Range <> “” And Sheet1.Range = “” Then。