VBA - Array that ignores zero's and blanks?

Hi All,

Is it possible to have an array that ignores 0's and blanks?

Current problem i'm facing, i have a list of numbers (which can change daily - with the 0's and blanks it doesn't exceed 2,000 rows) I want to be able to take the array of Col A and for it to produce a string i.e. '290','5000','24012' etc

I need each number to be separated with ','

In the attached file the outcome is in Cell D2 (Ignoring 0's and blanks)

Any help with this would be great,

Thanks in advance!

A single codeline starter demonstration :

PHP Code: 

[D2] = "'" & Join(Filter(Evaluate(Replace("TRANSPOSE(IF(A2:A#,A2:A#))", "#", [A1].End(xlDown).Row)), False, False), "','") & "'" 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » !

Thanks for the quick reply Marc,

Sorry - i Don't quite understand your response? I get type mismatch

I can't reproduce your issue as it works like a charm on my side with your attachment …

Apologies, my mistake.

This does indeed work! Thank you!

Thanks for the rep' !

You should test both ways with a zero in A2 …