Forum Discussion
Copy/Paste Macro using ActiveSheet
See the attached workbook. So that you do not have to worry about malicious code executing upon opening the workbook, this is not a macro-enabled workbook. Instead, I placed the relevant code into the _Code worksheet. But read the information on the _Info worksheet first.
Change
strRange = "B2:B9;B11:B21"
to
strRange = "B2:B9,B11:B21"
(comma instead of semicolon)
I messed with it a little the other day, and did what you have posted. I also had to add parenthesis around the argument to get it to work. Now Im researching how to make it so when I transfer to the next sheet it uses the first cell available in that range. So if something is already in cell B2 then it will transfer to the cell below. If not it will go to cell B2. Even if it originated from lets say cell B4 on the previous sheet it will transfer to cell B2 for the next sheet. I do thank you for your help. Im at least able to use this at work now since you gave me the code.