function 合并单元格(){ var lastr=ActiveSheet.UsedRange.Rows.Count; for (var i=lastr;i>=3;i--){ if (Cells(i,"d").Value()==Cells(i-1,"d").Value()){ Range(Cells(i,"d"),Cells(i-1,"d")).Merge(); } }}
function 删除指定的行(){ var lastr=ActiveSheet.UsedRange.Rows.Count; for (var i=2;i<=lastr;i++){ if (Cells(i,"d").Value2 == "北京" || Cells(i,"d").Value2 == "陕西"){ Cells(i,"d").EntireRow.Delete(); i-=1; } } }
本节先分享到这里,祝大家每天都有进步。
联系客服