I have 100 rows with a total at row 101.
when I use LastRow = .Range("c" & .Rows.Count).End(xlUp).Row
it stops at row 101 because of the totals. I need to start at C100 then find the last used cell or look for the second last used row.
My print range will be B1: O & what ever row it finds
when I use LastRow = .Range("c" & .Rows.Count).End(xlUp).Row
it stops at row 101 because of the totals. I need to start at C100 then find the last used cell or look for the second last used row.
My print range will be B1: O & what ever row it finds
