mpeterson
04-20-2019, 06:51 AM
Hi all,
I have a large data sheet made of 8 columns (A:H) and over 45000 rows.
Data are sorted into sets of variable number of rows. Each set of data is separated from the following with one blank row.
I am in need to only highlight all the FIRST ROWS of those data sets. In other words, I need to highlight the first row after every empty row.
The follwoing code highlights only the last row in the data sets, but what I need is the reverse.
Sub HighlightLastRow()Range("A1:S" & Range("A" & Rows.Count).End(xlUp).Row).FormatConditions.Add(xlExpression, xlEqual, "=OFFSET($A1,1,0)=""""").Interior.Color = vbYellow End Sub
May I get some help with this question please?
All the best
M.
I have a large data sheet made of 8 columns (A:H) and over 45000 rows.
Data are sorted into sets of variable number of rows. Each set of data is separated from the following with one blank row.
I am in need to only highlight all the FIRST ROWS of those data sets. In other words, I need to highlight the first row after every empty row.
The follwoing code highlights only the last row in the data sets, but what I need is the reverse.
Sub HighlightLastRow()Range("A1:S" & Range("A" & Rows.Count).End(xlUp).Row).FormatConditions.Add(xlExpression, xlEqual, "=OFFSET($A1,1,0)=""""").Interior.Color = vbYellow End Sub
May I get some help with this question please?
All the best
M.