Thread: Way to hide rows when a cell contains numbers less than a value?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Way to hide rows when a cell contains numbers less than a value?
Event code.

Private Sub Worksheet_Calculate()
If cell.Value < 123 Then
Rows(somerows).EntireRow.Hidden = True
End Sub

If you used the large white space to describe your needs we can probably
tailor a solution to those needs.


Gord Dibben MS Excel MVP

On Wed, 20 May 2009 09:01:01 -0700, lcExcelUser
wrote:


Reply With QuoteReply With Quote