Concatenate Array

Concatenate Array
Yesterday I made a post about concatenating range with strings in Excel. But there is one problem, it does not work with array formulas. So you cannot put condition on one column and based on that concatenate values form another. For this you would need a function like the one below. And a sample use.

Rounding in VBA and Excel

You never know how Microsoft may surprise you. If you think that everything is so obvious try using Round function as an Excel formula and in VBA. Typing in spreadsheet =Round(2.5, 0) will give you as a result 3. While “the same” function in VBA ? Round(2.5, 0) will result in 2. This feature  was included ...