Forum

I mistyped its the back color thats supposed to change, but I now changed it to forecolor and it works. thanks

Thanks, I tried with the case select but it doesnt appear to do anything it runs but doesnt change font and skips over the Application.Caller Shape

File attached it has links to ther files so graphs wont change but everything else should work

Thanks Riny, thats perfect, I still get confused with unpivoting etc

Hi, This has been working fine until a third page was added, now the transform sample file (2) is blank and the query gives a couple of errors E...

Thanks Catalin, I can't get my customers IT team to change for now so I do as you suggested wrote a macro to update all to xlsx and going forward w...

@Catalin I just downloaded it from here to check and the file attached above 20210112-Daily.xls has the same data in AE1 and AE16 there is a LEN f...

Update I still can't get it to work unless the first row has more than 255 chars in every file I was hoping that it would work with the sample file...

I have cleaned the files as much as possible but there are some extra queries I couldnt delete. daily file is the data file I added the bits in yel...