nth row

I need to set the row height of specific rows, starting at Row 33 and ending at Row 2208, with the offset of each row from the last being 29. It must only perform the row height change if there is a value in the previous cell in column B. i.e. Set Row Height for Cells B33, B62, B91, B120...

Hey All, Been working on this for a while and couldn't figure it out, tried offset, and Match/INDEX. I still cant get around the issue of the range not being a consistent nth row. <tbody> 10:00 100% 10:01 95% 10:02 100% 10:03 95% 10:04 92% </tbody> As the above table illustrates the...

Hi guys, I am trying to plot a graph but I have a lot of data. I have 213,792 rows of data but Excel only lets you plot 32,000 data points on a graph. How do I plot every 7th row of data instead? Below is a small look at what my columns look like (and the rows would be filled in of course)...

Hi All, I have a sheet where i want to enter one row and it then automatically calculates all the dates below it. However the problem I have is that i want it to calculate every nth day in a certain month so not sure what the formula or code is. Eg I have the following table: <tbody> Start...

I am trying to insert 6 blank rows after every 6 rows of data using a macro. I have this code but it just inserts 1 blank row every 6 rows of data. Sub Insert7thRow() Dim rCell As Range, l As Long For Each rCell In Selection l = l + 1 If l Mod 7 = 0 Then rCell.EntireRow.Insert Next...

I have a spreadsheet that I would like to add a row every 4th row and subtotal the numbers in the columns D-H (last five columns: <TABLE style="WIDTH: 590pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=786 border=0><COLGROUP><COL style="WIDTH: 110pt; mso-width-source: userset...

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List"...