| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden property not working when deleting a row?
Oh, I didn't know the Application.Volatile mehod! I just put this line
at the begining of my function and it works even when deleteing rows by VBA code! On Error Resume Next If rng.Rows(1).Hidden < rng.Rows(1).Hidden Then Application.Volatile (True) Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unable to set hidden property | Excel Programming | |||
| [Interops] OutlineLevel and Hidden property | Excel Programming | |||
| 'Saved' Property not working | Excel Programming | |||
| Run Time Error 1004 Unable to set hidden property | Excel Programming | |||
Threaded Mode
