Forum

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

Hi Maurizio, Because there are a finite number of images I wouldn't bother writing a VBA routine to get them from the web and then save to a folder...

Hi, Why do you need a macro for that? If you can explain in detail what you need and provide a workbook with an example of what you want to happen...