Forum

Hi Sean, Your VBA is password protected. Can't open it to debug it. Phil

Hi Steve, If there's nothing in the list you'll get this error. To check if there's nothing in the list you'll need to do something like If...

Hi Steve, Please supply your workbook and code. Too hard to debug without them. regards Phil

Hi Steven, It's always best to supply your workbook and code so we can see exactly what you are working with and give a better answer. Is the va...

Hi, Please see attached. The code for generating he email is taken from this post : VBA to create email and send with Outlook Regards Phil

Hi Lea, Insert (menu) -> Object -> Create from file (tab) -> Browse Insert an Object in Excel - Microsoft Regards Phil

OK so Q currently contains a date - you'll change this so it contains "expired" or some other text? What will the contents of the email be?

Hiya, Yes, changing a cell value would trigger an event that would then run the VBA to send the email. In order to do this I'd need to know what...

Hi, I'd usually look to do something like this using a Worksheet_Change event but unfortunately changing the colour of a cell does not trigger a ch...

1. Select the Format icon (the paint roller) 2. Click on Y-Axis to expand it 3. Scroll down and click on Title to toggle it off/on Regards ...

Hi, Please supply your workbook and data and a clearer explanation of what it is exactly you want to happen. Please supply as much information...

Hi, That saved search link takes me to a page that requires a login. We'll also need to know exactly what information you want from the page(s) ...

Hi Aye, I can't open that doc, Word tells me there's something wrong with it, and the file size is only 162 bytes. You can just upload an image ...

Hi Sara, I'd highly recommend that your data is organised into a tabular format and create a table so that reporting and formulas can work more easi...

Hi Sean, No workbook is attached. Regards Phil