cutting list optimizer

1. I want to open an existing workbook in excel with Visual Basic2008 2. Everything works fine until the code to Hide rows. 3. I have a code below but it doesn’t work 4. I do not know how to link the module (if needed) to my project 5. My project is exe and works from a Form in Visual Studio Button Clicand excel should be hidden 6. My workbook has 2 worksheets. Worksheet 1 and 2 7. In worksheet 2 where blank cell is in range A, entire row should be hidden or deleted 8. I want to copy to worksheet 2 but without the entire row where blank cells are found (A) 9. I would like to print worksheet 2 only