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

[Shafty]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Interest Amount[/TD]
[TD]Acceptance Amount[/TD]
[/TR]
[TR]
[TD]>0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]>0[/TD]
[/TR]
</tbody>[/TABLE]

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"}]