Deleting lines with a variable.
 

Hello,

In my macro I want to delete some lines depending on a test.
I loop through some lines and do a check whether to delete the line.
I've a linenumber stored in a variable i. The range object does not
seem to accept my varaiable however. If I just enter the variable e.g.

Worksheets(asset).Range(i).Delete
or
Worksheets(asset).Range(i:i).Delete

Excel will not accept it. If I add quotes I get:

Worksheets(asset).Range("i").Delete (which is not accepted)
or
Worksheets(asset).Range("i:i").Delete (which deletes a column instead
of a row)

So, how do I delete a line with a linenumber stored in a variable? If
it's not allowed to use a variable in the rangeobject, what would be an
efficient work around?

Thanks in Advance
Wilco

Deleting lines with a variable.
 

this would delete row 10 on sheet1

Sub r()
i = 10
Worksheets("sheet1").Rows(i).EntireRow.Delete
End Sub

--


Gary


wrote in message
ups.com...
Hello,

In my macro I want to delete some lines depending on a test.
I loop through some lines and do a check whether to delete the line.
I've a linenumber stored in a variable i. The range object does not
seem to accept my varaiable however. If I just enter the variable e.g.

Worksheets(asset).Range(i).Delete
or
Worksheets(asset).Range(i:i).Delete

Excel will not accept it. If I add quotes I get:

Worksheets(asset).Range("i").Delete (which is not accepted)
or
Worksheets(asset).Range("i:i").Delete (which deletes a column instead
of a row)

So, how do I delete a line with a linenumber stored in a variable? If
it's not allowed to use a variable in the rangeobject, what would be an
efficient work around?

Thanks in Advance
Wilco

Deleting lines with a variable.
 

Ok, Thanks a lot!