I have this VBA im trying to get working, its basicly a check for if a Value is present in column A then it should cut last 4 characters of string in Column B on corresponding cell for that row.
However im getting error 7 out of memory...

can someone please help?

have tried restart computer

HTML Code: