Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? -- Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy/Paste cell down to next value- Easy question, can't figure it | Excel Discussion (Misc queries) | |||
copy down question | Excel Worksheet Functions | |||
Copy/Paste Question | Excel Discussion (Misc queries) | |||
copy question | Excel Programming | |||
Copy Paste Question | Excel Discussion (Misc queries) |