View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Upanisad Upanisad is offline
external usenet poster
 
Posts: 4
Default 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!