I'm not versed in VBA ( and actually this is a non VBA forum) but what is CONCATENATE(A" & intRow & ", "" "", B" & intRow & ") supposed to do ?

Non VBA syntax is =concatenate(string1,string2, etc..) or without the concantenate function = string1&string2&...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post