my data is "c" rows long, where c is a variable that determines the data row count. The data starts at line 3 and I need to copy the first three columns. So it's a rectangle starting at A3 and going to C(c+2). I know how to move rows from one sheet to another, but can't figure out how to call just a group of cells. I tried Sheet1.Cells(3 - (c + 2), 1 - 3).Copy but it didn't like that.
How do I reference a range of cells in visual basic to copy from one sheet to another?
- Thread starter Reset
- Start date