Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste cells using VB
Hi all! I am a new poster and also a neophyte Visual Basic user. I am
trying to create a macro that will cut the odd ranges in (B9:B649) to (A9:A649). There is data in the even ranges I will want to move up in column B when I get the odd data moved to column A. I've seen a lot of options for ranges of consecutive cells but am lost when dealing with random cells. My last attempt was: Sub CutAndPaste() Dim X As Integer Dim Y As Integer Dim Sum As Integer Y = 1 For X = 8 To 648 Sum = X + Y Range("BSum").Cut Destination:=Range("ASum") Next End Sub I was hoping I could use the Sum value as my row indicator but it doesn't work. I appreciate any input! Dennis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste cells using VB
One way:
Sub Test() Dim i As Range For Each i In Range("B9:B649") If i.Row Mod 2 < 0 Then _ i.Cut i.Offset(, -1) Next i End Sub HTH Otto wrote in message ups.com... Hi all! I am a new poster and also a neophyte Visual Basic user. I am trying to create a macro that will cut the odd ranges in (B9:B649) to (A9:A649). There is data in the even ranges I will want to move up in column B when I get the odd data moved to column A. I've seen a lot of options for ranges of consecutive cells but am lost when dealing with random cells. My last attempt was: Sub CutAndPaste() Dim X As Integer Dim Y As Integer Dim Sum As Integer Y = 1 For X = 8 To 648 Sum = X + Y Range("BSum").Cut Destination:=Range("ASum") Next End Sub I was hoping I could use the Sum value as my row indicator but it doesn't work. I appreciate any input! Dennis |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste cells using VB
Otto,
Thanks a lot!!! That worked perfectly! Dennis On Jan 8, 5:00 pm, "Otto Moehrbach" wrote: One way: Sub Test() Dim i As Range For Each i In Range("B9:B649") If i.Row Mod 2 < 0 Then _ i.Cut i.Offset(, -1) Next i End Sub HTH wrote in oglegroups.com... Hi all! I am a new poster and also a neophyte Visual Basic user. I am trying to create a macro that will cut the odd ranges in (B9:B649) to (A9:A649). There is data in the even ranges I will want to move up in column B when I get the odd data moved to column A. I've seen a lot of options for ranges of consecutive cells but am lost when dealing with random cells. My last attempt was: Sub CutAndPaste() Dim X As Integer Dim Y As Integer Dim Sum As Integer Y = 1 For X = 8 To 648 Sum = X + Y Range("BSum").Cut Destination:=Range("ASum") Next End Sub I was hoping I could use the Sum value as my row indicator but it doesn't work. I appreciate any input! Dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
Copy Cells/Paste Cells Programatically | Excel Programming | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) |