To the right of what exactly? A specific cell? The ActiveCell? Something else?I would like a macro that can select 8 cells on the right and also selecting 3 rows down
Try this line of code:I would like a macro that can select the current cells and 8 cells on the right as well as selecting 3 rows down for copying
Range(ActiveCell, ActiveCell.Offset(3, 8)).Copy
ActiveCell.Resize(3, 8).Copy