Unable to set the ShowDetail property of the Range Class

Hi,

When backtesting this code it worked fine. Now I am tying to test it & it isnt working.

Please Login or Register  to view this content.

When I hit the error & go to debug. I made the application.visable=true & it worked.
Does anyone know why it works that way & more importantly what I can do to fix it?

Doesnt seem to work: With wS either.
Neither does:
wS.Rows(18).EntireRow.ShowDetail = False

Guess I could try closing & re opening Excel

Okay, so it works flawlessly the 1st time through.
Its throwing the error if I have the code do the same thing,
but this time it should be UnGrouping Rows & then unhiding them.
Then applying the new Groups & hiding the detail.

I got past that error by replacing: .ShowDetail = False with .Hidden = True
It ran so slow with everything off .Visible & ect....
Then switched everything back to how I wanted it with the .ShowDetail = False

Weird it ran super slow again, but finish with .ShowDetail = False.

Closed my workbooks & Excel then Reopened then did a little Compile magic, ran the code again knowing its not going to error the 1st time only the 2nd.

Ran it again & lo & behold no problem, & it did it as fast as it should have. Rinse & repeat a few more times & no more problems.

It wasnt closing & re-opening everything because I had already done that & it was still failing.
I dont think it was Compile that saved my bacon either. [Im 80% sure I did that already when I closed & re opened]
Oddly I think it was .Hidden = True that fixed whatever was wrong with my sheet/sheets.

I have no idea but it is working now, just sharing my weird experience.