When you insert rows in excel you need to tell excel which row you can't just do
Rows.Insert Shift:= xlDown
so i made a variable called linenumber which keeps track of the row number but then i can't seem to make it insert a row by reffering to the variable

eg

Rows(linenumber).insert shift:= xldown

could someone help.plz