Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help writing a macro please!
I need help writing a macro.
I have a worksheet of columns A - D, with 100 rows. I need to hide the row if the value in column C is 0. I can get the macro started in row 1 of column C by recording a macro and selecting that cell, but from there I don't know what to do. Thanks soooooo much! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help writing a macro please!
hi
Sub mcarter() Dim r As Range Dim rd As Range Set r = Range("c1") Do While Not IsEmpty(r) Set rd = r.Offset(1, 0) If r.Value = 0 Then r.EntireRow.Hidden = True End If Set r = rd Loop MsgBox "done" End Sub "mcarter" wrote: I need help writing a macro. I have a worksheet of columns A - D, with 100 rows. I need to hide the row if the value in column C is 0. I can get the macro started in row 1 of column C by recording a macro and selecting that cell, but from there I don't know what to do. Thanks soooooo much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing macro | Excel Programming | |||
Macro Writing | Excel Programming | |||
Need Help writing a macro | Excel Programming | |||
Macro Writing Help? | Excel Programming | |||
Writing Macro | Excel Programming |