[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?
How to make it work? Is loops a mandatory to populate an Array?
<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?
Code:
Range("A1:B3").value = Array("Interest Amount","Acceptance Amount",">0","","",">0")