Delete - Shift Cells UP problem

Hi

I setup a toolbar icon to automate the delete-shift cells up function but
sometimes it shifts cells up and other times it shifts them to the left, how
can i have it just do shift UP?

thanks

Ralph

Selection.Delete Shift:=xlUp

should always move the cells up.

Regards

Trevor


"Ralph" <Ralph@discussions.microsoft.com> wrote in message
news:B5EBAE8B-1663-4A76-975A-A69CB645738A@microsoft.com...
> Hi
>
> I setup a toolbar icon to automate the delete-shift cells up function but
> sometimes it shifts cells up and other times it shifts them to the left,
> how
> can i have it just do shift UP?
>
> thanks

Trevor, thanks, but you're a bit over my head, maybe I should explain better:
I setup a toolbar icon by going "view:toolbars:customize" and chose the one
that is for deleting cells...but it is inconsistent

"Trevor Shuttleworth" wrote:

> Ralph
>
> Selection.Delete Shift:=xlUp
>
> should always move the cells up.
>
> Regards
>
> Trevor
>
>
> "Ralph" <Ralph@discussions.microsoft.com> wrote in message
> news:B5EBAE8B-1663-4A76-975A-A69CB645738A@microsoft.com...
> > Hi
> >
> > I setup a toolbar icon to automate the delete-shift cells up function but
> > sometimes it shifts cells up and other times it shifts them to the left,
> > how
> > can i have it just do shift UP?
> >
> > thanks
>
>
>

Ralph

ahhhh, sorry. Excel tries to be helpful ... as ever.

What I'm not sure about are the "rules" that it applies. If there is data
in the cells that you have selected * I think * it does the following:

if you have several cells in a row selected, it assumes you want to move the
cells below up.

if you have several cells in a column selected, it assumes you want to move
the cells below left.

if you are deleting cells in a "blank" area it seems to default to "up"

and if you are deleting a single cell in the midst of other data it assumes
"up"

It's probably very logical when you see the pattern

Regards

Trevor


"Ralph" <Ralph@discussions.microsoft.com> wrote in message
news:5266DFAB-2476-4D68-9D80-E753AB4E6703@microsoft.com...
> Trevor, thanks, but you're a bit over my head, maybe I should explain
> better:
> I setup a toolbar icon by going "view:toolbars:customize" and chose the
> one
> that is for deleting cells...but it is inconsistent
>
> "Trevor Shuttleworth" wrote:
>
>> Ralph
>>
>> Selection.Delete Shift:=xlUp
>>
>> should always move the cells up.
>>
>> Regards
>>
>> Trevor
>>
>>
>> "Ralph" <Ralph@discussions.microsoft.com> wrote in message
>> news:B5EBAE8B-1663-4A76-975A-A69CB645738A@microsoft.com...
>> > Hi
>> >
>> > I setup a toolbar icon to automate the delete-shift cells up function
>> > but
>> > sometimes it shifts cells up and other times it shifts them to the
>> > left,
>> > how
>> > can i have it just do shift UP?
>> >
>> > thanks
>>
>>
>>