找到添加/删除的行/列 [英] Locating added/removed rows/cols

问题描述

我有两个几乎完全相同的工作表，我需要找到它的不同之处。但是当然可以添加行/列和删除的行/列。

其余的表可能是相同的。有没有办法（不使用跟踪）识别只有两个工作表的添加/删除的行/列？因为工作表来自客户，我不能使用诸如sheetselectionchange等事件。

tnx提前，

arie

解决方案

抱歉，有意链接这篇文章。

https://social.msdn.microsoft.com/Forums/en-US/81445cf7-37dc-446d-81fa-6b3654a99bf4/compare-and-find-added-rows ？forum = exceldev

Hi,

I have two almost identical worksheets and I need to find the difference in this. But there can of course be added rows/cols and removed rows/cols.

The rest of sheets might be identical. Is there a way (without using tracking) to identify added/removed rows/cols just having two worksheets? because the worksheets are from a client I can't use events like sheetselectionchange etc.

tnx in advance,

arie

解决方案

Sorry, meant to link to this post.

https://social.msdn.microsoft.com/Forums/en-US/81445cf7-37dc-446d-81fa-6b3654a99bf4/compare-and-find-added-rows?forum=exceldev

这篇关于找到添加/删除的行/列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！