How to disable the moving dottined line when copying

[Nitro2481]

Hi Guys,


I have the following VBA code

Please Login or Register  to view this content.

When I acativate the red bit I am left with the "copy dotted moving line" around AB

and when I activate the black bit I am left with the dotted line aroung D.

How do I turn this off?

I am attaching the full code in the VBA module below incase there is anything there that needs changing.

Please Login or Register  to view this content.

Thanks in Advance

[TMS]

Use

Please Login or Register  to view this content.

[Greg M]

Hi there,

If you're copy/pasting only values (not formats), it's much more efficient to assign the values from the source range to an array, and then to assign the values in that array to the target range - this also avoids dotted lines and leaving the target range selected at the end of the operation.

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Nitro2481]

Thanks a mil guys,

Greg that formula seems to have worked perfectly. Really smooth with no obvious copying and pasting.

Thanks so much

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M