I need to select a different title block in a project. I have tried .Activate() and I'm able to add title blocks to the list of title blocks - but cannot change it programmatically.
While you are in a sheet, click on the title block to highlight it, then at the top of Properties side bar click on the the little down arrow next to the exisitng Titleblock that is currently in-use and select the new title block that you want from the drop down list. That should be all there is to it.
To do this using the API you will need both the FamilyInstance element of the title block you wish to change and the TypeId of the title block family you wish to change it to.
You should then be able to use the FamilyInstance.ChangeTypeId() method to change its family and/or type.