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
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