Last seen: Aug 29, 2025
Hi David, This line .To = WorksheetFunction.VLookup (Range("B2").Value, Worksheets("Staffs").Range("Staffs"), 2) should be .To = Worksheet...
Hi David, Please be specific about the problem. How was it not successful? Did you get a VBA error? If so, please tell me what it was. A scre...
Not sure what you mean, you'll have to be more specific. In the file I supplied, the value entered into B2 gets copied to L2 and then N2 for plotti...
Hi, I don't know if you have dynamic arrays (available in Office 365) so I've written a solution that doesn't use them - see attached. The chart...
Hi Nesha, If you are all running Microsoft 365 (presumably you are all part of the same business tenant?) then you should set up the OneDrive app o...
Hi Bill, Google search results are location specific. The results it gives me when I search here in Australia will most likely be different to wha...
Hi Maria, No file is attached. You need to click the Start Upload button - instructions can be found here Regards Phil
Hi Howard, It's much easier to do this kind of thing directly in the command line. Writing VBA to call FSO is just using the Windows Shell/Command...
No problem Bill. Where do you want to get the company website address from? Looking at the results I get when searching, for 3M the 1st search ...
Hi, Please attach your workbook. Have you tried using the code in this blog post Plotting Real Time Data Regards Phil
Hi Daria, When I tried to open your file Excel told me that the VBA project and macros were corrupted. Can you please attach another copy of the...
Hi Bill, Please start your own topic if you have a question, don't tag on to someone else's topic. Your code doesn't work because you're looking...
No worries Robb.
You're welcome.