Forum

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...

Hi Shiva, I'm not sure why you are trying to count the number of merged cells. Don't use merged cells. Unmerge them and then use 'Center Across...

Hi Ginger, Without seeing your workbook and code it's hard to know how you are doing this, but if you have some code that updates Sheet1 every hour...

Hi, We need more information! 🙂 I'm guessing you meant to attach a workbook? Phil

Hi, I'm very unclear to what it is you are trying to do. Can you please try explaining it again and in your workbook show the source data and th...

Hi, You've mis-spelled MsgBox Your line should be MsgBox "You have entered wrong info!", vbCritical When the error is generated the VBA de...

Hi Maurizio, Have you gone through these posts Regards Phil

Hi Khushboo, You could use IF but only for small numbers of records, and the records/rows would need to be sorted ascending or descending based on ...