kbrown2974
05-26-2004, 10:16 AM
I am currently working on a macro to take a range of cells and add it into another range. So far all I have working is that it copies the range. I want the copied range to be added into the range that is pasted. Code is below:
colcounter = 0
Do While colcounter <= src1counter
Range(source1(colcounter)).Select
Application.CutCopyMode = False
Selection.Copy
Range(dest1(colcounter)).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
colcounter = colcounter + 1
Loop
Any suggestions?
colcounter = 0
Do While colcounter <= src1counter
Range(source1(colcounter)).Select
Application.CutCopyMode = False
Selection.Copy
Range(dest1(colcounter)).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
colcounter = colcounter + 1
Loop
Any suggestions?