How to paste an Array of Values in an Excel Sheet?

[Shafty]

Interest Amount	Acceptance Amount
>0
	>0

<tbody>
</tbody>

Need to create the above criteria Range for an advanced filter... (in runtime)

Why the below code is not working?

Range("A1:B3").value = Array("Interest Amount","Acceptance Amount",">0","","",">0")

How to make it work? Is loops a mandatory to populate an Array?

 

[pgc01]

Hi
Welcome to the board

You have a 2D array in the left side and a 1D array in the right side. Not clear what one would expect from such a statement.

You can try, for ex.:

Range("A1:B3").Value = [{"Interest Amount","Acceptance Amount";">0","";"",">0"}]