Last seen: Jun 11, 2026
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.
Hi Carine, You can read how to use DSUM here Regards Phil
Hi Astrit, Yes I think you could log in to the same OneDrive account more than once, I haven't tried it. But you have the ability to share file ...