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

Selection.Delete Shift:=xlUp

This needs a selection first.

The macro recorder can be your friend. Try it

--
Don Guillett
SalesAid Software
[email protected]
"serdar" <[email protected]> wrote in message
news:[email protected]...
> Selection.Delete Shift:=xlUp
>
> This needs a selection first.
>
>

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" <[email protected]>, haber iletisinde şunları
yazdı:[email protected]...
> The macro recorder can be your friend. Try it
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "serdar" <[email protected]> wrote in message
> news:[email protected]...
> > Selection.Delete Shift:=xlUp
> >
> > This needs a selection first.
> >
> >
>
>

range("a1:c3").Delete Shift:=xlUp
--
Don Guillett
SalesAid Software
[email protected]
"serdar" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]>, haber iletisinde şunları
> yazdı:[email protected]...
> > The macro recorder can be your friend. Try it
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "serdar" <[email protected]> wrote in message
> > news:[email protected]...
> > > Selection.Delete Shift:=xlUp
> > >
> > > This needs a selection first.
> > >
> > >
> >
> >
>
>

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.

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?

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

--
Don Guillett
SalesAid Software
[email protected]
"serdar" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
>

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" <[email protected]>, haber iletisinde şunları
yazdı:[email protected]...
> I'm still not sure EXACTLY what you want to do???????????
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "serdar" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> >
> >
>
>

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

--
Don Guillett
SalesAid Software
[email protected]
"serdar" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]>, haber iletisinde şunları
> yazdı:[email protected]...
> > I'm still not sure EXACTLY what you want to do???????????
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "serdar" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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?
> > >
> > >
> > >
> >
> >
>
>