I'm not able to open a password protected spreadsheet. if you need to delete a specific row you can use Rows(index).EntireRow.Delete; where index = the row (number) you want to delete. For example to delete Row 3; Rows(3).EntireRow.Delete
Posts by gerryjam
Please enable macros on the attached example. Then go to the first sheet and click the GetDays button. Enter the Month-Year in MMM-YYYY format. the results are then shown on sheet 2. Enjoy.
you could try a msgbox to stop the screen and show the correct value; it also highlights the correct value on the screen. Please see the button_click event.