Limiting deletion of cells

[GARY]

Is there a way to delete cells within a range of columns without
affecting cells outside of the range?

 

[James Ravenswood]

Is there a way to delete cells within a range of columns without
affecting cells outside of the range?

If you Clear the cells rather than Delete them, it will have a smaller
impact.

 

[GARY]

If you Clear the cells rather than Delete them, it will have a smaller
impact.

My goal is to delete empty cells so the subsequent cells are moved to
the left but without affecting cells outside of the selected range.

 

[GS]

GARY was thinking very hard :

My goal is to delete empty cells so the subsequent cells are moved to
the left but without affecting cells outside of the selected range.

You can copy the cells to the right over the cells you want to clear,
then clear the cells to the right.

 

[Lynz]

GARY was thinking very hard :

You can copy the cells to the right over the cells you want to clear,
then clear the cells to the right.

Edit, delete, move cells to left?

 

[GS]

Lynz used his keyboard to write :

Edit, delete, move cells to left?

Use Copy <destination> to move the data to the left.
Clear the unused cells to right.

 

[Don Guillett]

Lynz used his keyboard to write :







Use Copy <destination> to move the data to the left.
Clear the unused cells to right.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -

- Show quoted text -

A looping macro within another looping macro can do this easily.

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."