Hi there, been puzzling over this one to the point of destruction!

Can someone help.....please!!!

For Each c In Range("b67:fe67")

If c.Value < 200 Then
c.EntireColumn.Hidden = True
Else
c.EntireColumn.Hidden = False
End If

Next
Ok, so there's my basic code.

I have a ss with a load of data on, the last row being the totals. I need to hide any columns that are less than 200 which my code does. The problem I have is that the data changes daily and therefore the end row can be different, therefore B67 can easily be B100, so I need some way of finding the last row and putting this into my code.

Something like

For Each c In Range("bx:fex")
where x is the number of the row.

Any ideas what I can do?

Thanks in advance