Selecting rows with variable
try this
count_y=20
Rows("4:" & count_y ).entirerow.delete
"Jim" wrote in message
...
Im trying to select, then delete a whole lod of rows in
one go. Im trying to use the following commands:
Rows("4:" & count_y ).Select
Selection.Delete Shift:=xlUp
It doesn't like this at all. How can I get it to do what
I want?
|