Forum

Hi, This is why supplying the actual workbook and thoroughly explaining the expected result is so important. The work I did in my first answer was...

Hi, Please provide a workbook rather than typing data and code so we don't have to recreate everything. You can do what you want with a combinat...

OK so what you want to do is see if an error has occurred when sending an email. You need to know how to handle errors in VBA I've added a new sub...

Hi Stefi, You can't have a formula that takes a value from a cell, and then ignores when that value changes. What I've done is changed the formu...

Hi Mark, You say that other users 'seem to' have the same permissions. Can you confirm this is actually the case? On the face if it, your files...

Dick's 2nd file

Hi Paul, Without your actual file that is giving the errors I can't try to replicate the issues you're having. regards Phil

upload/attach the workbook with the code to a reply in here

Hi Paul, There are no macros in that workbook. It's an XLSB so perhaps somehow in the conversion from XLSM to XLSB the code modules were removed...

Hi Andi, It's really difficult to give you an answer without seeing the code in your workbook, can you please attach it to this post. It's not r...

Hi Stefi, If you just want to change the values in some of the ColB cells then just change the formula in those cells. If you only want cells ...

David, Please supply a workbook otherwise we have to spend time typing in the data that you should already have at hand. Also, typing in data li...

Hi Robert, Please see the attached workbook. By moving the code that loops though each workbook, you can create a PDF for each and then add each o...

Hi Melinda, This might help you with CF Regards Phil

Hi Vic, Not sure why you can't attach a .xlsm, there is no restriction on such files and I never have any issues. Are you getting an error message...