array concatenate

I have a data set in a range, A3:B104. Using the following code, I can assign that data set to an array. Public Sub ItemArray() Dim rg As Range Set rg = ThisWorkbook.Worksheets("Summary").Range("A3:B104") Dim Tracking As Variant Tracking = rg.Value Dim i As Long, j As Long For i =...

Hi everyone! Here is a task about array, I can't resolve. I have the array like {text1,text2,text3} and I want to joint elements of the array in string like "text1text2text3" I try to use array formulas, but it doesn' work :( Why Mcrosoft haven't realize sum-like formula for text :confused...

I am looking for a looping function that will capture cell addresses and plug them into an array. The array then gets used in a formula. I pictured using the offset technique to move the cursor over 2 columns, evaluate if greater than 0, if so store the cell address and then create the formula...

HI! I've searched and experiemented, but I can NOT get <acronym>VBA</acronym> to post sequential message box values into a spreadsheet. What I'm trying to do is to loop through, e.g. spreadsheet cell (1,2) = textbox1.value; spreadsheet cell (2,2) = textbox2.value; etc. Following some advice...

Hi Wondering if anyone could help me with my post from yesterday entitled Complicated If Search Array Concatenate Problem. Cheers, Guy

Hi My project is becoming a complicated mess with pages of simple formulas slowly searching data and concatenating it together. Please help me to find a simple formula I can use. Here is a simplified example of my project. I need a formula in B2 of Sheet3, ideally that I can fill down, that...