Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I got a macro earlier and I try it and get a runtime error? The purpose of
the code is to hide entire rows if a 0 value is with in the specified range of cells. Also I would like it to be in the form of a check box. If the box is checked it hides the rows and if it is unchecked it shows the rows with a value of 0 in them. The help I received earlier was greatly appreciated, just want it to work... For Each cell In Range( "AL35:AL609") cell.Entirerow.Hidden = cell.Value = 0 Next cell Thanks, Sean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |