tropics123
Board Regular
- Joined
- May 11, 2016
- Messages
- 85
Hi, any help on this is greatly appreciated!
I'm trying to find the last row with data and highlight it yellow. I started with finding the last row but don't know the rest
Help!
Sub HighlightLastRow()
Dim LastRow As Long
With Sheets("Sheet1")
LastRow = .Cells(.Rows.Count, 1).End(xlUp).Row
I'm trying to find the last row with data and highlight it yellow. I started with finding the last row but don't know the rest

Sub HighlightLastRow()
Dim LastRow As Long
With Sheets("Sheet1")
LastRow = .Cells(.Rows.Count, 1).End(xlUp).Row