Hi Riny van Eekelen, You have obviously done something workable in the attached file.. I'll try following applaid steps.. But how does the functio...
Hi Catalin, Sorry to say, but your suggestion neither solves the question regarding matching SupplNr, nor the problem with nested loop for Transact...
Hi Mynda, You write "Similarly, the From and To Dates have no relationship to the UBW data because the UBW table doesn't have those same fields, th...
Catalin: Very interesting - and it's working!! Actually, a bit confused now...but happy! First of all, I've never seen a "full" reference like t...
Hi Catalin, You’re rigth about the Cells(Row,Column) referanse. However the problem in sub Test2 seems to be copying from Sheet1 to Sheet2, erro...
Hi again, Attached is a small Excel VBA workbook with array defined in VBA code Sheet1. "Test1" is working: Sub Test1() Dim Arr As Variant 'rea...
Catalin Bombea said Hi Trond, What is not working? It does not make sense to go through sheet ranges row by row and read the values into an arr...
Catalin Bombea said Not seeing anything strange in Arr = Sheets(Sh.Name).Range("AT5:BZ5").Value Point is, the fixed reference is working (for i = 5,...
Hi Catalin, Thx for being here, trying to help me a bit.. Also know just part of code is uploaded, entire workbook is well over 20mb and to much to...
I've made my first Array now, and understand the point with it. However a bit unsure if this is a 1D or 2D reference: Arr = Range("B5:O5) , I suppose...
VBA attached as zip file instead of txt. Don't know why failing to upload attachments, but seems to happen when editing post.
Hi Catalin, Unfortunately I'm not into arrays like you are. But see what you say about "writing takes time" to Excel, using If Then and Do While pr...
Excel matrix uploaded (again), with corresponding VBA loop procedure in TXT file attached as well. Colors in Excel file; - yellow sheet = input (3 ...