Compare Differences in Blank Ranges across sheets

E

ExcelMonkey

I have blank cells on Sheet1. I am using the following code to print out a
range of blank addresses to the immediate window:

Selection.SpecialCells(xlCellTypeBlanks).Select
Debug.Print Selection.Address

$C$1:$E$2,$A$1:$A$2,$G$1:$G$2,$C$3:$D$3,$F$1:$F$3,$C$4:$G$6,$B$1:$B$5,$A$4:$A$6

Now I have copied the data on this sheet to a second sheet and purposely
inserted two rows (3 and 7) and two columns (E and H). When I rerun the
code, I get a revise list of addresses below

$C$1:$I$3,$A$1:$A$3,$C$4:$E$4,$G$4:$H$4,$C$5:$I$8,$B$1:$B$7,$A$5:$A$8

Here is my question: Is there a way in VBA to compare the two multiple
range strings to back into which rows/columns were inserted?

Thanks

EM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top