Inserting a line....

  • Thread starter Thread starter Brady Snow
  • Start date Start date
B

Brady Snow

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
 
Hi
best way: start from the bottom. So move upwards. Same is true if you
want to delete rows
 
You must log in or register to reply here.

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

Similar Threads

Can Vba workout if a selection is part of a group? 0
Keeping formulas on an insert 1
Insert copied cells above hidden Named Range 3
Changes in How Code Acts After Upgrade of Excel 2
Insert Row Above and Calculate Difference Between Dates 2
Inserting rows 2
Insert cells 1
Select a specific row in named range 7

Back
Top