What would be the macro line to highlight the last row to color green according to col A
Cheers
What would be the macro line to highlight the last row to color green according to col A
Cheers
Last edited by rain4u; 02-12-2011 at 06:40 PM.
Cells(Cells(1, 1).EntireColumn.Cells.Count, 1).End(xlUp).EntireRow.Interior.Color = 5296274
Last edited by nimrod; 02-12-2011 at 05:14 PM.
Works like a charm.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks