Changing copy to Cut

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

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
 
Hi
try
rng2.Cut Destination:=Worksheets("Exceptions_Report").Range("A8")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 3
Exception Report 1
Error Problem 1
Copy Array Formula 4
CUT not COPY but errors 8
Creating sheet and copying filtered rows in it 3
Problem inserting cut range 2
Compare and copy dose nothing 2

Back
Top