I normally use the following statement to copy the second cell located to the right of the found cell back into the original worksheet:
AtiveCell.Offset(0, 2).Select
ActiveCell.Copy
Worksheets("Tab1").Select
ActiveSheet.Cells(l, 7).Activate
ActiveCell.PasteSpecial
The above works fine. However I would like to use a range instead, i.e.I would like to copy the second, third and fourth cell located to the right of the found cell. I used the following:
Range(ActiveCell.Offset(0, 2), ActiveCell.Offset(0, 4)).Select
ActiveCell.Copy
Worksheets("Tab1").Select
ActiveSheet.Cells(l, 7).Activate
ActiveCell.PasteSpecial
However the above does exactly the same as the first macro? Any ideas why?
PS: what should I use to copy and paste the 2nd, 3rd and 5th cells to the right in one go?
Thanks,
Antoine
Bookmarks