excel - 跨多个工作表删除相同的行号

Question

我正在寻找一个宏，当我从 sheet1 中删除该行时，它将根据多张工作表上的行选择删除相同的行号。示例：如果我删除 sheet1 上的第 5 行，我希望自动删除 sheet2 上的第 5 行，无论表是否存在。有人可以帮忙吗？

标签： excelvbadelete-row

Answer 1

I'm not sure what your use is, but you can right-click your sheet and 'Select All Sheets', then when you delete a row from your active sheet it will also delete that row from all the selected sheets. This will not affect your hidden sheets.