Why does Range.Rows.Insert sometimes not work?
 

I have a macro that inserts a row into a named range (yes, I know, the naming
has to be updated manually in many cases); sometimes this works and sometimes
I get the "Insert Method of range object failed." with no other explanation.