How to delete a range and shift the rest up in Vbasic?

[serdar]

Selection.Delete Shift:=xlUp

This needs a selection first.

 

[Don Guillett]

The macro recorder can be your friend. Try it

 

[serdar]

nope. i creates this code:

Selection.Delete Shift:=xlUp

i want to delete lets say a1 to c3. i can do it with select but i dont want
selection is shown to the user before deleting the area. i must say smt like
"shift the list up starting from the 4th row" I tried:

Range(xxx).Delete Shift:=xlUp

but this doesn't work.

 

[Don Guillett]

range("a1:c3").Delete Shift:=xlUp

 

[serdar]

Range(x).Delete Shift:=xlUp
or
Rows(x).Delete Shift:=xlUp

These should work but since i dont define the rest of the list, it shifts
the entire document up.

 

[serdar]

Ok i tried it with an if statement.

If Range("a11") = "serdar" Then _
Rows(10).Delete Shift:=xlUp

My fault was trying it just in the event function and it continuosly shifts
the list, true?

 

[Don Guillett]

I'm still not sure EXACTLY what you want to do???????????

 

[serdar]

Thats ok now, don't get angry with me. Because i wrote a delete command in
the change event function without a control statement, change event deletes
and shifts continuosly.

 

[Don Guillett]

Not angry, perplexed... This is the first mention of a change event.
Use application.enableevents=false