Thanks for everyone sharing their knowledge - I have learned SO much...! Now... taking the first step - admitting you have a
I'm running thru a Range - and for each change in value - inserting a new row. OK - no problem.
However, I would like this newly inserted row to be formatted in some way, then have the routine continue on it's
merry way until finding another row that needs to be inserted.
For example - maybe I want to change the row
height, or change the Interior color from Columns A thru Z for example - or any other formatting desired.
reached my limit on trying to accomplish this - so now reaching out...!!!
small section of relevent code:
If CILineNameRange.Cells(x, 1).Offset(-1, 0).Value CILineNameRange.Cells(x, 1).Value Then
CILineNameRange.Cells(x, 1).EntireRow.Insert shift:=xlDown
' the above inserts a row - but I
would like to insert a colored row from say... colums A thru Z,
' and maybe change the row height, or whatever other formatting desired
' - such as
' .ColorIndex = 15
' .Pattern = xlSolid
' .RowHeight = 4.00
Many thanks in advance!