Runtime Error 1004 while copying dinamic ranges

Hi all,

I´ve just a problem while copying the range from on to another worksheet.
The Problem ist, the source range is dynamic, so it increases if common criteria in the cells match.
I´m a vba noob, so be merciful with me. The actual code is an mixture of code shunks

Please Login or Register  to view this content.

hopefully somebody can introduce , how I fix these problem.

regards

Hi Codeslizer,

I´m passing values from arrays.

arrP1 = Array("TRUE", "True", "TRUE")
arrP2 = Array("*", "*", "*")
arrAct = Array("copyLine", "copyLine", "copyLine")

Maybe, If I take this makro running I´ll define more copy possibilities

Originally Posted by romperstomper

What is this line supposed to mean:

Please Login or Register  to view this content.

What is the third WS1 supposed to be doing?

Oh ****, certainly nothing.
If your are searching for code error it´s like looking to a mandelbrot set.

:-P

Ok, as I said bevor, I´m a greenhorn.
The copy paste code it´s a bulk of waste

Now I´ve updated it.

Please Login or Register  to view this content.

Data is copied to the destinaiton sheet, but only one row
Loops are also a red rag