how to hide rows that have values from 0 to 40 in one column depending on top
value of 3 cells? TIA

a1=2 b1=5 c1=4

result:
0
1
2
3
4
5

Hi TiDz,

Your question is unclear.

Please try to re-explain your needs.

--
---
Regards,
Norman



"TiDz" wrote in message
...
how to hide rows that have values from 0 to 40 in one column depending on
top
value of 3 cells? TIA

a1=2 b1=5 c1=4

result:
0
1
2
3
4
5

Hi Norman,
I'll try :)
I've values in one column in 41 rows from 0 to 40 and I need left of that
such quantity depending on top value of 3 cells:
if:
a1=2 b1=5 c1=4
result:
0
1
2
3
4
5
or if:
a1=3 b1=1 c1=4
result:
0
1
2
3
4


"Norman Jones" rašė:

Hi TiDz,

Your question is unclear.

Please try to re-explain your needs.

--
---
Regards,
Norman



"TiDz" wrote in message
...
how to hide rows that have values from 0 to 40 in one column depending on
top
value of 3 cells? TIA

a1=2 b1=5 c1=4

result:
0
1
2
3
4
5

Hi Norman,
I'll try :)
I've values in one column in 41 rows from 0 to 40 and I need left of that
such quantity depending on top value of 3 cells:
if:
a1=2 b1=5 c1=4
result:
0
1
2
3
4
5
or if:
a1=3 b1=1 c1=4
result:
0
1
2
3
4


"Norman Jones" rašė:

Hi TiDz,

Your question is unclear.

Please try to re-explain your needs.

--
---
Regards,
Norman



"TiDz" wrote in message
...
how to hide rows that have values from 0 to 40 in one column depending on
top
value of 3 cells? TIA

a1=2 b1=5 c1=4

result:
0
1
2
3
4
5

Hi TiDz,

Try:

'=============
Public Sub Tester()
Dim WB As Workbook
Dim SH As Worksheet
Dim rng As Range
Dim iMax As Long
Dim i As Long
Const col As String = "H" '<<==== CHANGE

Set WB = Workbooks("YourBook.xls") '<<==== CHANGE
Set SH = WB.Sheets("Sheet1") '<<==== CHANGE
Set rng = SH.Range("A1:C1") '<<==== CHANGE

iMax = Application.Max(rng)

SH.Columns(col).Insert

For i = 0 To iMax
SH.Cells(i + 1, col).Value = i
Next i

End Sub
'<<============



---
Regards,
Norman

"TiDz" wrote in message
...
Hi Norman,
I'll try :)
I've values in one column in 41 rows from 0 to 40 and I need left of that
such quantity depending on top value of 3 cells:
if:
a1=2 b1=5 c1=4
result:
0
1
2
3
4
5
or if:
a1=3 b1=1 c1=4
result:
0
1
2
3
4


"Norman Jones" rase:

Hi TiDz,

Your question is unclear.

Please try to re-explain your needs.

--
---
Regards,
Norman



"TiDz" wrote in message
...
how to hide rows that have values from 0 to 40 in one column depending
on
top
value of 3 cells? TIA

a1=2 b1=5 c1=4

result:
0
1
2
3
4
5

Thanks, Norman
but it doesn't work for me
likely it's my blame after complicated explanation :)

it's inserting a new column, but I need to do auto "hide/unhide" of rows in
fixed range "a1:a41" (not by inserting a new column) depending by entering a
diferent values from 0 to 40 in 3 fixed cells...

any suggestion?.. :)



"Norman Jones" rašė:

Hi TiDz,

Try:

'=============
Public Sub Tester()
Dim WB As Workbook
Dim SH As Worksheet
Dim rng As Range
Dim iMax As Long
Dim i As Long
Const col As String = "H" '<<==== CHANGE

Set WB = Workbooks("YourBook.xls") '<<==== CHANGE
Set SH = WB.Sheets("Sheet1") '<<==== CHANGE
Set rng = SH.Range("A1:C1") '<<==== CHANGE

iMax = Application.Max(rng)

SH.Columns(col).Insert

For i = 0 To iMax
SH.Cells(i + 1, col).Value = i
Next i

End Sub
'<<============



---
Regards,
Norman

"TiDz" wrote in message
...
Hi Norman,
I'll try :)
I've values in one column in 41 rows from 0 to 40 and I need left of that
such quantity depending on top value of 3 cells:
if:
a1=2 b1=5 c1=4
result:
0
1
2
3
4
5
or if:
a1=3 b1=1 c1=4
result:
0
1
2
3
4


"Norman Jones" rase:

Hi TiDz,

Your question is unclear.

Please try to re-explain your needs.

--
---
Regards,
Norman



"TiDz" wrote in message
...
how to hide rows that have values from 0 to 40 in one column depending
on
top
value of 3 cells? TIA

a1=2 b1=5 c1=4

result:
0
1
2
3
4
5

Hi TiDz,

If you wish, you may send me a sample workbook.In one sheet, show your
intial data; in another sheet, show the desired results.

norman_jones@NOSPAMbtconnectDOTcom

(Delete "NOSPAM" and replace "DOT" with a full stop [period] )

---
Regards,
Norman



"TiDz" wrote in message
...
Thanks, Norman
but it doesn't work for me
likely it's my blame after complicated explanation :)

it's inserting a new column, but I need to do auto "hide/unhide" of rows
in
fixed range "a1:a41" (not by inserting a new column) depending by entering
a
diferent values from 0 to 40 in 3 fixed cells...

any suggestion?.. :)