Copy/paste several hundred values from 1 sheet to many

[johnnybastow]

Calling all you amazing gurus out there!!
Have used the following after a lot of research and trying several methods.
The source range consists of values dotted about within a rectangular range, within a single sheet. The target range consists of multiple sheets.
The below is just a test - the full copy has a lot more values.

'Ftime' below reports at 4.6 seconds. Have I overlooked something please?
---------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

[Fluff13]

Why are you multiplying the time by 1000?
The elapsed time in seconds is simply

Please Login or Register  to view this content.

[johnnybastow]

yes you're correct but the elapsed time really is 4.6 seconds, unfortunately, not 0.0046.

[Fluff13]

Do you have any conditional formatting?
That code takes ~3 thousandths of a second for me

[johnnybastow]

thanks again for the reply.
Your comment implies that conditional formatting (CF) is an issue even when recalc is switched off...I wasn't aware....

I removed CF on the INC sheet, it didn't make much difference. I have quite a bit of CF on other sheets though...

Also fyi the spreadsheet is very complex, with links galore, complex calculations, 47 sheets, I'd assumed these facts aren't relevant though as the recalc is switched off and operation I'm trying to do is self-contained with code exactly as specified.

Many thanks.

[Fluff13]

CF will recalc regardless of the calculation state.
If it takes over 4 seconds to do what you showed in your op, then something else is happening.
Without seeing your workbook, I have no idea what.

[johnnybastow]

I've found the problem. It was the camera tool, which has slowed the assignment of values by a factor of somewhere in the region of 10-100 times, depending on other things.
I've also found the solution which is to replace the camera tool image with a named range, conditional on the value of a single cell.
The solution is on this forum but ironically it won't let me paste the link.
Fluff13 thanks for your input, it helped me to get there.

[Fluff13]

Glad you sorted it & thanks for the feedback.