method range error

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 I've written some code to determine whether I need to delete or insert cells in to spreadsheet (depending on whether I have more or less data than the last time the code was run). If the sheet I'm deleting the cells from is active then the code runs fine. However, the sheet won't normally...

I have been using this piece of code within the same workbook, on other sheets and it works just fine. It simply selects a range of cells and uses the "Zoom to Selection" function aka "ActiveWindow.zoom = true" to fit the sheet properly on the screen. I use this because the workbook is opened on...

Hello, Im trying to make something that will manipulate data consistently across multiple workbooks. I am having trouble with the 255 character limit of the FormulaArray function (I tried the .replace workaround and I'm not sure if I did it correctly) and when I'm not getting that error I'm...

Hey everyone! I'm currently working on a project where I need to create 5 tables (one for each business day) and populate them with data from another page in the same worksheet. Right now I'm doing this by simply adding rows to the tables that already exist and already have VLookups set up the...