VBA Optimization help for Large string manipulation related to memory management?

JKPieterse 

Right, I did try that 

Private Sub OptimizedMode(ByVal enable As Boolean)
     Application.EnableEvents = Not enable
     Application.Calculation = IIf(enable, xlCalculationManual, xlCalculationAutomatic)
     Application.ScreenUpdating = Not enable
     Application.EnableAnimations = Not enable
     ' Application.DisplayStatusBar = Not enable
     Application.PrintCommunication = Not enable
End Sub

From the website here.

https://vbacompiler.com/optimize-vba-code/

The idea you are providing with arrays, is point 6 from this blog post correct?

https://techcommunity.microsoft.com/t5/excel/9-quick-tips-to-improve-your-vba-macro-performance/m-p/173687

Dim vArray As Variant
Dim iRow As Integer
Dim iCol As Integer
Dim dValue As Double
vArray = Range("A1:C10000").Value2 ‘ read all the values at once from the Excel cells, put into an array 

For iRow = LBound(vArray, 1) To UBound(vArray, 1)
  For iCol = LBound(vArray, 2) To UBound(vArray, 2)
    dValue = vArray (iRow, iCol)
    If dValue > 0 Then 
      dValue=dValue*dValue ‘ Change the values in the array, not the cells 
    vArray(iRow, iCol) = dValue
  End If
Next iCol
Next iRow
Range("A1:C10000").Value2 = vArray ‘ writes all the results back to the range at once

So, I haven't tried this yet.

I'm confused with this part from above

For iRow = LBound(vArray, 1) To UBound(vArray, 1)
  For iCol = LBound(vArray, 2) To UBound(vArray, 2)
    dValue = vArray (iRow, iCol)

With regards to Lbound(vArray, 1) & again the loop Lbound(vArray, 2)

What is 1 & 2 referring to?

and when we put them back with 

Range("A1:C10000").Value2 = vArray

is (vArray, 1) referring to A1? & the second loop is B1?

i.e a1 a2 a3 a4... then b1 b2 b3 b4....

So is C column not being looked at? but I'mma assume it is?

I understood the examples here

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/lbound-function

and here,

https://www.automateexcel.com/vba/ubound-lbound-function/

but didn't understand what and where I need to modify.

as is.

should I make vArray = Search_Range( entire H column) with tons of conversations,

then, cell = split(vArray(iRow,iCol), "||") then run my for loops?

if so, how am I putting the values back into the 25 columns the specific data needs to be entered into?

Cause, I am using cell(1, 20) etc, to reference which column I need to put it in.

and idk how to loop and assign properly.