Forum Discussion
VBA To Highlight Rows
Hi We have a piece of software that outputs an Excel file once a week, this file has to be organised and edited to show specific information, which is quite a tedious task! I am trying to produc...
It highlights the whole row because you selected cell.ENTIREROW.Interior…
If you know it is columns A:T then you could use
range("$a$" & cell.row & ":$T$" & cell.row).interior.colorindex = 6
as for the rows only being this month without seeing the book my thought is there may be a 'break' in data between the months causing your .End(xlup) to only select to that point. If you want it to go all the way up to row 2 then just explicitly set that.
That all said, this all seems like a simple conditional formatting rule. Have you tried that?
If you know it is columns A:T then you could use
range("$a$" & cell.row & ":$T$" & cell.row).interior.colorindex = 6
as for the rows only being this month without seeing the book my thought is there may be a 'break' in data between the months causing your .End(xlup) to only select to that point. If you want it to go all the way up to row 2 then just explicitly set that.
That all said, this all seems like a simple conditional formatting rule. Have you tried that?
mtarler
Thanks, that seems to have at least get it highlighting just the table.
The are no breaks in the data, other than they are not consecutive.
Quick screen shot of the data:
Conditional formatting won't work as it is a new spreadsheet that is generated every week and has to be altered to produce a report.
