Turns out that that code snippet only works if the table is already filtered, in this case a column is filtered on ="Yes" if I clear the filter I get ...
Thanks Catalin, once again your awesome grasp of M comes to the rescue, next time I'm allowed into Ro I'll buy you a beer or two. John
Hi Phil delete was probably the wrong action to include, as a follow up question how about the opposite. If there are 6 columns do x if there are &...
Hi I have tried adding a piece of code to check rotation but that has no effect ... ActiveSheet.Pictures.Insert (sFile) If ActiveSheet.Shapes...
Hi Lionel I have added the workbook and three pictures and a screen shot of where the macro places them Clicking in L3 Landscape correct orientatio...
Thanks Catalin didnt know that despite filter it hardcodes and also try/otherwise is a new one for me. Now I just have to get the way the .pdf repo...
Hi Catalin, I have split the query and will add the try otherwise error catch. I just dont see how the Orders_Page2 query errors out when I thou...