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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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