There is no target cell per say. Because this in the middle of execution the control shifts from primary code to template code.
Primary code here is a loop having to split one workbook to multiple workbooks and
each workbook should have incorporated change event macro in it. The template file is used for this purpose.
below is the primary code, after the line highlighted in yellow executes, the control transfers to template cod