This seems to work - not test extensively
Sub CopyJump()
myrange = Range("MON!A7:A80")
j = 5
For Each mycell In myrange
Worksheets("MON LOG").Cells(j, 1).Value = mycell
j = j + 3
Next
End Sub
bets wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"thomsonpa" wrote in message
...
I have 2 worksheets and I am looking for a macro that will copy a range of
cells from one worksheet, then paste them to another worksheet, but leave
2
blank cells between each cell.
sheet to copy from "MON" range: A7:A80
sheet to paste into "MON LOG" starting at cell A5, paste then leave 2
cells
blank, next cell A8, etc. until all of the copied range A7:A80 has been
pasted.
Any ideas?