Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare Differences in Blank Ranges across sheets
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to compare worksheets so differences are identified | Excel Worksheet Functions | |||
Compare and Highlight Differences | Excel Programming | |||
Compare data with in a couple of sheets then output to a blank sheet | Excel Programming | |||
Compare and report differences. | Excel Programming | |||
Compare 2 columns to see differences | Excel Worksheet Functions |