I have a worksheet (ABC) that pulls data from another sheet that has unique data entries (DEF) beginning every 9 lines and has an undefined length. For ABC I have formulas that reference cells for each entry, so I created a loop to copy the 2nd row of the sheet which has all of the formulas and paste it 9 rows down, then delete the 8 rows in between that I do not need.
I am having an issue with my code that gives me the error "Run-time error '1004': Method 'Range' of object'_Worksheet' failed". I defined variables for the sheets and had the errors so I tried using the full "Sheets("ABC").Range" code which didn't fix it, so I tried selecting the sheet then pasting to the selection which also did not work. I had a similar issue on another of my macros but was able to figure it out and fix the problem with these troubleshooting tactics.
Below is my code:
Thanks in advancePlease Login or Register to view this content.
Bookmarks