Hi - I am trying to create a macro that will select the last row of cells in column CA:EH and drag them down through the previous quarter end. To do this I have created a function to get the number of rows the data must be pulled down called weekCount.
However, I am having an issue with coding the AutoFill range. I think that it's getting confused between row or select. I'm also not sure that I formatted the AutoFill range correctly for this scenario. Can someone please take a look at the code below?
Please Login or Register to view this content.
Bookmarks