Excel VBA:运行时错误“1004”:选择范围类方法失败。

I am writing a macro to work in an excel sheet that is saved within a template then exported to .xls or .xlsx from a separate application. This macro is to copy two columns 'x' number of times depending on a quantity that is entered into a cell.I am writing a macro to work in an excel sheet