G
Gary Keramidas
what's the best way to copy a column of data with data in every other row?
for example, this range could vary, but it's what i was trying to accomplish,
copy all cells at once
Range("B5,B7,B9,B11,B13,B15,B17,B19,B21,B23,B25").copy
and then paste them into a different sheet
now this works, but does one cell at time
For Each cell In Range("b5:b25")
If cell.Row Mod 2 = 1 Then
Range("b" & cell.Row).Copy
End If
Next
and so does this:
For i = 5 To Lastrow Step 2
Sheets("sheet1").Range("b" & i).Copy
so how would you dynamically replace the odd numbers in my first example so all
cells are selected at once? and does it even matter if they're done all at once
or a cell at a time?
for example, this range could vary, but it's what i was trying to accomplish,
copy all cells at once
Range("B5,B7,B9,B11,B13,B15,B17,B19,B21,B23,B25").copy
and then paste them into a different sheet
now this works, but does one cell at time
For Each cell In Range("b5:b25")
If cell.Row Mod 2 = 1 Then
Range("b" & cell.Row).Copy
End If
Next
and so does this:
For i = 5 To Lastrow Step 2
Sheets("sheet1").Range("b" & i).Copy
so how would you dynamically replace the odd numbers in my first example so all
cells are selected at once? and does it even matter if they're done all at once
or a cell at a time?