Pain in the ass macro Part 2
 

I am creating a macro that contains a for loop that runs through colum
E and checks the value of each cell. If the cell equals 0 then it hide
the entire row and moves down to the next cell, and if it has a value i
does nothing and moves on. As I am writing the code I am getting erro
after error. Any help with this matter would be greatly appreciated
Thank yo

--
Jesse
-----------------------------------------------------------------------
JesseK's Profile: http://www.excelforum.com/member.php...fo&userid=2496
View this thread: http://www.excelforum.com/showthread.php?threadid=38526

Pain in the ass macro Part 2
 

iLastRow = Cells(Rows.Count,"E").End(xlUp).Row
For i = 1 To iLastRow
If Cells(i,"E").Value = 0 Then
Rows(i)Hidden = true
End If
Next i

--
HTH

Bob Phillips

"JesseK" wrote in
message ...

I am creating a macro that contains a for loop that runs through column
E and checks the value of each cell. If the cell equals 0 then it hides
the entire row and moves down to the next cell, and if it has a value it
does nothing and moves on. As I am writing the code I am getting error
after error. Any help with this matter would be greatly appreciated.
Thank you


--
JesseK
------------------------------------------------------------------------
JesseK's Profile:
http://www.excelforum.com/member.php...o&userid=24964
View this thread: http://www.excelforum.com/showthread...hreadid=385263

Pain in the ass macro Part 2
 

Bob,

In order to help Jesse remain calm, I'll point out that in the 4th line you
meant:

Rows(i).Hidden = true

Doug

"Bob Phillips" wrote in message
...

iLastRow = Cells(Rows.Count,"E").End(xlUp).Row
For i = 1 To iLastRow
If Cells(i,"E").Value = 0 Then
Rows(i)Hidden = true
End If
Next i

--
HTH

Bob Phillips

"JesseK" wrote in
message ...

I am creating a macro that contains a for loop that runs through column
E and checks the value of each cell. If the cell equals 0 then it hides
the entire row and moves down to the next cell, and if it has a value it
does nothing and moves on. As I am writing the code I am getting error
after error. Any help with this matter would be greatly appreciated.
Thank you


--
JesseK
------------------------------------------------------------------------
JesseK's Profile:
http://www.excelforum.com/member.php...o&userid=24964
View this thread:
http://www.excelforum.com/showthread...hreadid=385263