Reply to thread

Message: [QUOTE="RoyVidar, post: 9668587"] When I copy/paste your function into VBE, it first complains about the last End Function, which is supposed to be End Sub. Then it complains about Type Mismatch on the line If iTempCount = "" Then where you compare an integer with ZLS, which isn't supposed to be possible. I don't know what you intend with this test, but I suppose you could remove it. Or are you intending to test the content of the array? If sArray(iTempCount) = "" Then When this is fixed, there's no complaint about missing array on my setup. I suggest using Option Explicit at the top of each module, which helps pick up such as this. To ensure this is turned on in every new module, in Tools | Options, check "Require Variable Declaration". [/QUOTE]