Both of these codes go down 8 rows past the last row.
My headers are in Row 4 and the data starts in 5 down
Sub Find_FloorStock()
'Author: G Heyman 190221
'Update "Type" Find Floor Stock and change from B to F"
With Range("G5", Range("G" & Rows.Count).End(xlUp))
.Value =...