Inserting a line....
I have two worksheets that I am comparing numbers on.
Sheet 1 Range ABC and sheet 2 range XYZ. If the numbers match on both sheets I do not do anything. If they do not match I insert (Selection.Insert Shift:=xlDown) the number then loop through the process again. The problem I am having is after I do an insert(Selection.Insert Shift:=xlDown) it throws the line count off. For example if I inserted a number in sheet 1 and the next number to compare is row 2, It actually goes to row 3 because I inserted a row. This now throws the whole comparison off. Any Ideas on how to resolve this? Thanks in advance!! Brady Snow |
Inserting a line....
Hi
best way: start from the bottom. So move upwards. Same is true if you want to delete rows -- Regards Frank Kabel Frankfurt, Germany Brady Snow wrote: I have two worksheets that I am comparing numbers on. Sheet 1 Range ABC and sheet 2 range XYZ. If the numbers match on both sheets I do not do anything. If they do not match I insert (Selection.Insert Shift:=xlDown) the number then loop through the process again. The problem I am having is after I do an insert(Selection.Insert Shift:=xlDown) it throws the line count off. For example if I inserted a number in sheet 1 and the next number to compare is row 2, It actually goes to row 3 because I inserted a row. This now throws the whole comparison off. Any Ideas on how to resolve this? Thanks in advance!! Brady Snow |
All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com