Copy Range Border Excel 2007 + Screenupdating Issue

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

We are running a VBA macro and are copying a range and then looping and
inserting the copied range. However, the copied range has the "copy border".
Is there anyway this can be turned off in vba?

Also, we cannot turn off the screenupdaing using the following below

with application
.screenupdating = false
.displayalerts=false
end with

We think it is updaitng due to a custom function in the range being copied

Is there anything else that you can totally turn Excel updating off with.

Thanks in advance
 
To exit copy mode use Application.CutCopyMode = False

Don't know why you're having problems turning off the screen.

--
Jim
| We are running a VBA macro and are copying a range and then looping and
| inserting the copied range. However, the copied range has the "copy
border".
| Is there anyway this can be turned off in vba?
|
| Also, we cannot turn off the screenupdaing using the following below
|
| with application
| .screenupdating = false
| .displayalerts=false
| end with
|
| We think it is updaitng due to a custom function in the range being copied
|
| Is there anything else that you can totally turn Excel updating off with.
|
| Thanks in advance
|
 
Back
Top