Forum

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

Hi Ali, I'm confused. The topic title is 'Search for non-similar words in Excel', but your post asks to find indentical sentences. Which one is i...

The filename has a % in it which is probably causing the 400 error. Aye - please make sure the filename consists of just letters/numbers Phil

Nice work Sunny. Aye - attached is a VBA solution that uses RegEx in a UDF. You'll need to set a reference to the 'Microsoft VBScript Regular Expr...

Hi Daniele, I've emailed you. Regards Phil

Before I spend a lot of time on this, I have to ask, where does the data come from? Can't you do something at the source of the data to prevent the i...

OK, please upload a workbook with this data so I can work with that.