ExcelBanter - Changing copy to Cut

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Changing copy to Cut (https://www.excelbanter.com/excel-programming/294282-changing-copy-cut.html)

Edgar[_3_]

Changing copy to Cut

Hi

How could i change the following line so that it cuts the
range instead of copying it?

rng2.Copy Destination:=Worksheets
("Exceptions_Report").Range("A8")

TIA

Frank Kabel

Changing copy to Cut

Hi
try
rng2.Cut Destination:=Worksheets("Exceptions_Report").Range ("A8")

--
Regards
Frank Kabel
Frankfurt, Germany

"Edgar" schrieb im Newsbeitrag
...
Hi

How could i change the following line so that it cuts the
range instead of copying it?

rng2.Copy Destination:=Worksheets
("Exceptions_Report").Range("A8")

TIA

All times are GMT +1. The time now is 02:44 PM.