Limiting deletion of cells

  • Thread starter Thread starter GARY
  • Start date Start date
G

GARY

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

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

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.
 
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.
Click to expand...

You can copy the cells to the right over the cells you want to clear,
then clear the cells to the right.
 
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.
Click to expand...
Edit, delete, move cells to left?
 
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 -
Click to expand...

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."
 
Back
Top