PC Review


Reply
Thread Tools Rate Thread

Compare Differences in Blank Ranges across sheets

 
 
ExcelMonkey
Guest
Posts: n/a
 
      26th May 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare and highlight differences in 2 worksheets in same workbookand list differences in 3rd worksheet Joshua Houck Microsoft Excel Programming 21 19th Aug 2011 12:21 PM
Copy Two Visible Ranges (From Two Sheets) To A New Workbook (AlsoWith Two Sheets) septhemis@gmail.com Microsoft Excel Programming 3 30th Jan 2009 04:20 PM
Re: Copy Two Visible Ranges (From Two Sheets) To A New Workbook (AlsoWith Two Sheets) septhemis@gmail.com Microsoft Excel Programming 0 29th Jan 2009 01:35 PM
Compare data with in a couple of sheets then output to a blank sheet Sabo, Eric Microsoft Excel Programming 0 22nd Feb 2006 03:00 PM
How to locate differences between two sheets/ranges? =?Utf-8?B?R3J5em9y?= Microsoft Excel Misc 4 18th Jun 2004 10:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:35 PM.