arra

Hello I have created 2 functions F1 Function special_txttonr(text As String) Dim arr(), a As Long c = 0 For a = LBound(Split(text, ",")) To UBound(Split(text, ",")) ReDim Preserve arr(a) arr(a) = CInt(Split(text, ",")(a)) b = arr(a) x = WorksheetFunction.Max(b, c) c = x...

Is this possible? I have an array of IFs that's matches 1 row and returns a 4 column range, so 4 numbers. I can sum this fine but when I try passing it as the first argument in to sumproduct, I get a value! error. Here's some sample data: <tbody> 1 A B C D E F 2 apple mon 1 2 3 4...

Hi I've made a workbook with 14 different pivot charts - one pivot chart on each sheet. The pivot charts are all based on the same dataset coming out of access (one query feeds all charts - charts are set up manually). My original problem was that whenever I refreshed the data, all formatting...