Multi Dimensional Array

[Bill1234]

I have code with a multi dimensional array. The code searches for lines that have a certain number in a certain cell. When the array is pasted in a new worksheet, empty lines of data are kept. Is there a way for the array to skip rows that don't meet my if statement?

Please Login or Register  to view this content.

[PCI]

Perhaps see next code : NOT TESTED
Your code seems curious as is done a test like
Cells(i, 3).Value <> "0"
while column "C" do not have "0"

and CStr(s) do not have any value ...!

Please Login or Register  to view this content.

[Bernie Deitrick]

Try it like this:

Please Login or Register  to view this content.

[Bill1234]

Thanks, Bernie it works!

Bill