var app = Globals.ThisAddIn.Application;
// Define the range "A1:C100"
Excel.Range range = sh.Range["A1:C100"];
// Define the cell A8
Excel.Range cellA8 = sh.Range["A8"];
Excel.Range cellAA8 = sh.Range["AA8"];
// Check if cell A8 is within the range
var isCellInRange = app.Intersect(cellA8, range);
var isCellInRangae = app.Intersect(cellAA8, range);
isCellInRange==null //不在范围
isCellInRange!=null //在范围
vsto 判断单元格是否某个区域单元格中
最新推荐文章于 2024-06-13 14:57:46 发布