Last seen: Jul 27, 2026
Hi Amy, I've replied to you by email. Regards Phil
Your dates and times are still text. If you actually make them dates/times you'll be able to do your calculations. Regards Phil
Hi Shila, I'm not really clear on what your objective is. The values you have in the columns headed Date and Time aren't dates or times, they ar...
Good job Bob. The joy of coding. A single character in the wrong place can break the whole thing.
Hi Tina, I'm not really clear on what exactly you are asking - how to create a report you can open in a browser, or how to open that already create...
Hi Ken, If you were stepping through using F8, but you had error checking turned off, you wouldn't see any of the generated errors. Cheers Ph...
Hi Brittany, In I2 you just need =H2 Regards Phil
Hi Blanka, The PrintArea property requires a string data type, not a range I've modified the code so it works in both of the workbooks you suppli...
Hi Ken, There's multiple issues here and I can't get this code to run at all. Before I go through a few things to help there's a few things that y...
Hi Ken, So this is the same/similar to the qs you posted recently, or different? It's just that it's not working with a .xlsm when that xlsm file ...
no worries 🙂
Hi Bax, Sorry you can't do that with an embedded workbook either. Regards Phil
Hi Bob, As we'll be looping through every worksheet, but only saving some as PDF's, we need to have a way to flag that a sheet isisn't for exportin...
Hi Bax, If you hide a sheet that has a hyperlink to it, the hyperlink won't work. So there isn't a way to do this with an embedded workbook either...