Deleting lines with a variable.
- From: newsuser@xxxxxxxxx
- Date: 1 Oct 2005 19:18:21 -0700
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
.
- Follow-Ups:
- Re: Deleting lines with a variable.
- From: Gary Keramidas
- Re: Deleting lines with a variable.
- Prev by Date: Execute code after printing with the BeforePrint event
- Next by Date: Re: email on condition from "import external data"
- Previous by thread: Execute code after printing with the BeforePrint event
- Next by thread: Re: Deleting lines with a variable.
- Index(es):