Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting a line between different data | Excel Discussion (Misc queries) | |||
Inserting a line | Excel Worksheet Functions | |||
Inserting an Image or Line | Excel Discussion (Misc queries) | |||
Inserting an image or line | Excel Worksheet Functions | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) |