Forum

Thanks Anders, I missed counting the brackets, end result was a missing { and a missing ) in case anyone else is looking and want to rename the las...

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

Answer here

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...