You enter content and your data into these cells. Whenever you open Excel, the Excel worksheet contains cells to store the information in them. Make sure to download the attached file so you can work with this macro in Excel.A cell is an essential part of MS-Excel. You will need to adjust the macro to work for your project, which shouldn't be difficult to do given the above instructions. This macro, in its current form, only inputs some text every two rows. This tutorial gives you a template that you can use to run a macro on a cell at a specified interval of rows. If this is confusing, just download the attached file for this tutorial and read the comments and play around with the code it shouldn't take long to get either setup to work. To use this, comment-out the line: last_row = 10 and uncomment the above line and replace the 1 with the number of the column that contains the list of data. This allows you to run the macro when you already have a data set in the worksheet and don't want to hard-code the value for the last_row. This line sets the last_row variable equal to the last row of data that you have in the worksheet. This line of code: last_row = Cells(Rows.Count, 1).End(xlUp).Row is the only line of actual code and the rest is a comment.

I commented it out so it won't run by default. 'last_row = Cells(Rows.Count, 1).End(xlUp).Row 'change the 1 in the next line to the number of the desired column 'uncomment the next line to make the macro run to the end of the data in the column In the file attached to this workbook I included this piece of code: I left this code intentionally bare so that you can use it as a template and build upon it. In my example I put: Cells(cur_row, 1).Value = 'something' which will put the text 'something' into Column A every 2 rows (since 2 is the interval).

Your code goes here! is the section where you put the code that you want to run every so many rows. Last_row is the last row that this should run on. Set this to whatever interval you want.įirst_row is the first row in the worksheet that the macro should run on. Interval is currently set to 2 and that means that the macro runs every two rows.

You only need to change the interval, first_row, and last_row numbers. The macro in the workbook attached to this tutorial has a little more code and that is commented so you can understand it. If (cur_row - (first_row - 1)) Mod interval = 0 Then 'last row to go to - above version of this goes to the last row of the data in the prescribed column

Excel how many rows to a page