Hello Excel Experts,
I run this and came out error "Type mismatch" and the yellow highlights at the row ".Replace "AAA", FORMP5, lookat:=xlPart". Can anyone correct me, please?
Dim FORMP1, FORMP2, FORMP3, FORMP4, FORMP5 As String
It's really a pain when we need to breakdown the long formulas in excel into vba. Been trying to do below but I really don't understand why the XXX partial formula is unable to be displayed when I run the macro.
Here is my breakdown formulas in vba:-
Sub SLAMatrixResol()Dim FORMP1...