Posted to microsoft.public.excel.programming

external usenet poster

Posts: 40

Loop learning

Hiding entire row, if value in cell in column B is Yes.

Private Sub CAT()
Dim i As Long

For i = 1 To 25
If Cells(i, 2).Value = "Yes" Then
Rows(i).EntireRow.Hidden = True
End If
Next i
End Sub

Instead of using i = 1 to 25, can't I use the Count property? How would I do
that?

--
Howard

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Learning VBA	Neal	Excel Programming	2	May 25th 06 06:45 PM
Learning VBA	[email protected]	Excel Programming	3	March 9th 06 04:42 AM
CDs and learning excel	Tim	Charts and Charting in Excel	0	November 30th 05 12:57 AM
Just learning VBA..	Deb Lang	Excel Programming	1	October 22nd 03 11:46 PM
Learning VBA	Randy Harris	Excel Programming	2	September 6th 03 10:59 PM

All times are GMT +1. The time now is 11:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us