it does work very well indeed thank you very much
thank you

"Don Guillett" wrote:

Make sure it's in the sheet module of the desired sheet.
If your cell value is a number don't use the " "
Try this. If all else fails, send your wb to my address below

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("j3").Address Then
Dim x As String
Rows.Hidden = True
Select Case Target
Case 53: x = "82:97"
' Case 2: x = "4:8"
Case Else
Exit Sub
End Select
Rows(x).Hidden = false
End If
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jez" wrote in message
...
don
i did try this but could not get it working

more specific is this:
if cell J3="58" then unhide rows 82-97 otherwise hide them
i need to unhide it only for this account code
many thanks
jez


"Don Guillett" wrote:

Right click sheet tabview codeinsert thismodify to suit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("a1").Address Then
Dim x As String
Rows.Hidden = False 'Visible = True
Select Case Target
Case 1: x = "40:41"
Case 2: x = "4:8"


Case Else
Exit Sub
End Select
Rows(x).Hidden = True
End If
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jez" wrote in message
...
or to make it more clear:
if account 1 is selected then unhide or hide rows 40,41
thanks in advance
jez

"Don Guillett" wrote:

Sure, Details???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jaz" wrote in message
...
hello there
i wonder if anybody could help me with this

is there a way probably macro that hides rows or columns if a
specific
number is entered on A1 for example?
many thanks
jez