Is there a way to use the spreadsheet to write the code to the visual basic routine as it is running? If I can pass control to the spreadsheet and continue to run the VB script that would be the best of all worlds.