Cut and paste values only? to avoid copy>paste values> select initial cells>clear cells

[Carlo22]

Hi,

I'm looking for a way to easily move only values from one cell selection to another. The formating of both the source and the destination cells are to remain the same.

So far I couldn't manage to find a solution in this forum or elsewhere.

Does someone here have a solution? Thanks!

 

[wigi]

What range of cells needs to be cut? On what worksheet?
What is the destination for the cells? In fact, Excel VBA knows the method "Cut".
Also, if you use the Macro Recorder, you will be presented with working code.

But in general, I prefer copy and clear original cells...

 

[Carlo22]

Hi Wigi,
thanks for the reply. I was looking for a convenient and "fool"-proof method to do this. As my colleagues also have to work with the file, I try to keep VBA out of it and stay with the oldschool way of copy>paste>go back> delete.

 

[wigi]

Then you could teach your colleagues to do a copy/paste special values, and then go back to the first cell and clear the contents.

 

[Carlo22]

Hi Wigi,
I guess you're right. Another option would be to convert ranges into tables - that would at least allow moving of lines within the table while the remaining lines "make room".

Regards,
Volker

 

[wigi]

That's true Volker!