![]() ![]() This what I have for copying code across and this works fine. Sheets("Sheet1").Cells(1, 1).EntireRow.Copy So I guess I need assistance in how to insert a row of predetermined headers over row 1 of sheet 1 ( I want to write the actual header names into the macro code). I have a macro written that will copy row 1 of sheet 1 into every existing sheet, however, I need to not have to manually insert the first sheet's headers (it should be part of the macro). The way I currently have things set up is that my data is being inserted starting at row 2 of every sheet when that sheet is generated. I'm having a hard time looking up what I am trying to do because I am having a hard time putting what I am trying to do into words.īasically, what I am trying to do is take a set of headers (maybe 10-12 columns long) and, in a macro, I want to paste those headers over (replace) the current headers in row 1 of sheet 1.
0 Comments
Leave a Reply. |