Beginner VBA error

I believe you may be replying to the wrong thread.

Originally Posted by PaulM100

Why not using a formula?

=SUMPRODUCT(MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)

Is an array formula, so Ctrl+Shift+Enter