V teku

422405 Excel VBA Code Help

I have a macro that perfectly runs as required for a given set of data. However,when I double the data, after some time I get an error.

"Run-Time error 1004:

Delete Method of range class failed".

When I debug, it highlights this line of the code.

Sheets(q).Range(Sheets(q).Cells(lRow, 1), Sheets(q).Cells(lRow, 1).End(xlDown).Offset(-5)).[url removed, login to view]

I don't know if this is as a result of not having enough memory on my PC or something to do with the code.

My requirement is to have some one have a look at the attachment and see if it can be solved. That is be able to run the 88 matrices and more.

To test the data, the starting position is D4. There are 88 matrices, 49 of them are processed perfectly well.

P.S The file is large so if your PC is low on memory, it will take quite some time or even crush.

Znanja: Vse velja, Excel

Več: vba with, code line, vba time, vba for, vba error, excel vba with, excel vba or, excel vba help, excel vba and, end vba, vba excel macro, vba code excel, pc help, Macro vba, excel vba macro, Excel Macro VBA, delete attachment, debug excel, range macro excel, vba help

O delodajalcu:
( 6 mnenja ) London, Uganda

ID projekta: #2168273