This is so embarrasing because I've done this 1000 times in older versions of Excel. I can't get Goal Seek to run in a macro in Excel 2010:

Code:
Range("E8").GoalSeek Goal:=0, ChangingCell:=Range("C6")
I know the macro runs because I put in debug.print statements before and after the Goal Seek line, but executing the macro doesn't change anything on the sheet. I'm obviously doing something wrong but can't for the life of me figure out what it is. I can click E8 manually and use the Gool Seek function from the menus, but the macro just doesn't work.