Hi, I wanting a way to inject a dymatic macro into excel, this is the code I want to inject, at the moment it just spits it out to console,  and I copy paste it into excel any help would be appreciated Nigel Func _WriteMacro() ConsoleWrite ('Private Sub Worksheet_Change(ByVal Target As Range)' & @CRLF ) ConsoleWrite (chr(9) & 'NeedtoPay = Range("A1").Value' & @CRLF ) ConsoleWrite ('Select Case Target.Address' & @CRLF ) For $x = 3 to $_Repayment + 3 ConsoleWrite (chr