Finding the last row that contains a value, of a column

[riedyp]

Hello,
I am trying to select a cell in the last row that does not contain a 0. It is taking me to Row 54 but I want it to go to Row 37. The method I know is to go to a cell at the bottom of the sheet and "xlUp" so it will find the first value it finds. I want to do this but want to ignore all of the "0's" till it arrives at value "3.3" in Row 37.
Any method that would solve this would be greatly appreciated.

Private Sub UpdateButton_Click()
NewRow = ActiveSheet.Cells(1000, 3).End(xlUp).Row 'Goes to the last updated cell
ActiveSheet.Cells(NewRow, 3).Select
End Sub

 

[riedyp]

Actually, is there way for me to format that if any value in this range C24:C100 is = 0 then all of the values in that row are hidden?

 

[jasonb75]

Filter?

If you use a format then you will have empty rows in the middle, (rows 28 and 33 in your example).

Either filter, or an array formula to pull only non 0 values, looking at your picture that will probably need an extra column in order to work.