Last seen: Jun 11, 2026
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...
Hi Maurizio, ActiveChart refers to the currently selected chart, see this If you select a chart before running the macro, you can just use Active...
Hi Julie, If you change the name of the workbook you want to get data from, then you need to change that same name in the formula you want to creat...