_global failed

Hello below is my code, it works only 1/3 of the upper screen as expected, error msg comes out anywhere else. please help to identify the root cause. Thanks so much. Sub FindMax() ' Dim zoomCell As Range, zoomRng As Range, maxCell As Variant ActiveSheet.Cells.Interior.Color =...

Hi there, thanks for looking. I have a simple bit of code that I would like to loop through each column and then graph this. I have my dates in column A and then B, C, D..... etc are full of numbers. I would like them individually graphed into new sheets. I have written this code but for some...

Hi ive been trying to tweek an existing code but im getting this error when i run it. I've got a macro to copy info from one spreadsheet to another which worked fine until now. Im trying to add a section that also changes the colour of a cell when it moves the info across but this seems to be...