I'm new to VBA and can't figure out what is wrong with my code segment. I have a single worksheet with a range of data. I need to take that range of data and repeat it "X" number of times based on a userform entered variable. The range to be copied is defined earlier as "Code".
I need range Code to be copied and pasted starting at the next empty row and so on based on "R" number of times. R is a user form defined value for how many times that range needs to repeat.
I get a type mismatch error when running and debug indicates that the problem is in the .resize line of code.
Please Login or Register to view this content.
Bookmarks