i am comparing pairs of cells in a column of data using an if statement. if
the statement is false i would like to add a row between them. i have
created a macro that just adds a row but i dont know how to nest it in an if
statement nor do i know exactly how to make sure that excel knows that i want
to add the new row above. i have tried to copy and past in vb but i am very
new to this and hope someone can help. using excel 2003
--
BBoyd