Forum

Hi Dave, I think I can do this but it will take some time to code + test. I'll try to get back to you tomorrow. Regards Phil

Hi John, I've tried various things but can't achieve what you want. Reading up on it, it does appear to be a limitation within Excel. I've trie...

Hi John, This works fine for me and none of the text formatting is lost when a character is added to the beginning of the string Range("A1")....

Hi Maurizio, I'm not having any problem with this. If the cell A9 contains a date, then the formula =TEXT(A9,"DDDD") gives me the day of the week....

Hi Maurizio, I don't understand what you are trying to do then. It seemed that you were asking to extract the day from a date in ColA? Which is w...

Just copy the formula down ColB starting at B2 i.e. =TEXT(A2,"DDDD") =TEXT(A3,"DDDD") =TEXT(A4,"DDDD") =TEXT(A5,"DDDD") etc Phil

Hi Les, It's a timing issue. The VBA is working, but when you do ActiveWorkbook.RefreshAll VBA doesn't wait for the PQ query to do its thing. It ...

Hi Les, Can you provide the workbook please. Phil

Hi Kenn, I see you've cross posted this on Mr Excel and are receiving help there so I will leave you to that. Please don't cross post to other f...

Hi Maurizio, You can use this rather than VBA to get the day name in B2 =TEXT(A2,"DDDD") Regards Phil

Hi Hope, As Anders said, it's always better to supply a workbook with the data to make out lives easier to help you 🙂 But, try this =IF(ISER...

Hi Giannis, It depends on what you want the combined Subs to do. For example, you have If Target.Count > 1 Then Exit Sub in one Sub, do you w...

Hi David, There's nothing to prevent you uploading an image or Word doc to this post, it would be better to provide an Excel workbook though. Tr...

Hi Aye, Not sure exactly what you mean by 'export to' ? If you are using Teams then everyone should have access to One Drive and Sharepoint? ...

Hi Anne, Have you tried Kaggle? Regards Phil