About Us

Stephen[_24_]

Shouldn't...

For i = 31 To 1000
If .Cells(i, 21).Value = "0" And .Cells(i, 22).Value = "0" Then
..Cells(i, 1).EntireRow.Hidden = True
End If
Next i

hide each row where the values for columns "U" ANd "V" equal zero?

Bob Phillips

For i = 31 To 1000
If .Cells(i, 21).Value = 0 And .Cells(i, 22).Value = 0 Then
.Rows(i, 1).Hidden = True
End If
Next i

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stephen" wrote in message
...
Shouldn't...

For i = 31 To 1000
If .Cells(i, 21).Value = "0" And .Cells(i, 22).Value = "0" Then
.Cells(i, 1).EntireRow.Hidden = True
End If
Next i

hide each row where the values for columns "U" ANd "V" equal zero?

JLGWhiz

If .Cells(i, 21).Value = "0" And .Cells(i, 22).Value = "0" Then

Unless you have columns U and V formatted as text, you would need to
remove the quote marks from the zeros. It worked OK for me once I did that.

"Stephen" wrote:

Shouldn't...

For i = 31 To 1000
If .Cells(i, 21).Value = "0" And .Cells(i, 22).Value = "0" Then
.Cells(i, 1).EntireRow.Hidden = True
End If
Next i

hide each row where the values for columns "U" ANd "V" equal zero?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fill down produces correct formula but wrong answer	Jim at SDSU	Excel Worksheet Functions	2	March 3rd 06 07:03 PM
Converting Wrong Time Value to Correct One	daddylonglegs	Excel Discussion (Misc queries)	0	February 5th 06 11:42 PM
Formula correct, answer wrong	TJAC	Excel Discussion (Misc queries)	2	January 3rd 06 06:15 PM
Excel opens correct view - web (used frontpg) opens it wrong	Jim2003	Excel Discussion (Misc queries)	1	July 27th 05 10:25 PM
Formula Result Correct but value in the cell is wrong	jac	Excel Worksheet Functions	2	December 17th 04 08:05 PM

Menu

About Us