1. The string argument to the Evaluate function is evaluated by Excel's formula evaluator, not VBA, and
2. Your arrBool array is 2D, and Join only accepts a 1D array. 1-based, 0-based, or anything else-based doesn't matter.
1. The string argument to the Evaluate function is evaluated by Excel's formula evaluator, not VBA, and
2. Your arrBool array is 2D, and Join only accepts a 1D array. 1-based, 0-based, or anything else-based doesn't matter.
Last edited by shg; 11-05-2013 at 07:39 PM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks