I have been searching for about an hour now and I'm losing the will to live.
I know this is simple but I cannot get it to work. Nor find a solution here that suits.
I need to copy the values starting at the ActiveCell down 21 Cells in workbook1.
That is to say if the active cell in workbook1 is b20, I need to copy the values of b1 to b41 inclusive.
I then need to paste those values to workbook2,.one cell below the range "StartCell"
I have declared the values of Wb1 and Wb2 but cannot get the copy/paste to do what I need.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.