Need to speed up this code

[GeekBlueNose]

Hi guys,

Written this bit of code to copy from one spreadsheet to another. It runs really slow, how can I speed this up??

Please Login or Register  to view this content.

Reports = filename of other worksheet
ASM = sheet name


Any help would be appreciated..


Cheers,

[TMS]

Don't select workbooks, worksheets or ranges.

Use Application.ScreenUpdating = False before executing your code.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[GeekBlueNose]

Hi TMS,

I've used application.screenupdating = false in another sub wheich then calls thus sub...

I guessed that the reason it is slow is down to selecting the workbook and sheets but my VBA knowledge isnt good enough to write this another way.. I've tried but keep getting in a muddle, could you show me so I knwo in future

[TMS]

I've used application.screenupdating = false in another sub wheich then calls thus sub...

You may know that but no-one else has access to that code. Don't expect advice and guidance unless you share all the code, suitably redacted source and target files, with expected results.

I repeat: Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[MikeVol]

Hello @GeekBlueNose. Try next optimized code.

Please Login or Register  to view this content.

It was my pleasure to help you. Good luck.

[mjr veverka]

???

Please Login or Register  to view this content.

[MikeVol]

Hello @mjr veverka Method or data member not found in line:

Please Login or Register  to view this content.

The expression is highlighted:

Please Login or Register  to view this content.

???

[mjr veverka]

Method or data member not found ... ???

Sub allee_kiha()

... allee kiha ! ... that's true ! ... koozva ...

Please Login or Register  to view this content.

[GeekBlueNose]

Hi guys,

I managed to try your solution mike yesterday and it worked like a charm.. Thaks so much ... That bit of code is an absolute game changer for me..

mjrveverka No need to try your solution but do you think it's a better way of doing it, seems to use a bit less coding.