Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
this is the base of my script so far
Sub PasteSpecial() Dim DeleteRows As Range Range("A1:A3").Copy Range("C4").Select ' This is the problem Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True Set DeleteRows = Range("A1:A8") ' this deletes the row that I just copied. i.e. cut DeleteRows.Delete Shift:=xlShiftUp End Sub This works great but it will overlap, paste over paste, becuase I have the second range set to C4. I want some how for the C4 to change after every copy so it would be like this... Range("A1:A3").Copy Range("C4").Select ' This is the problem Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True Range("A1:A3").Copy Range("C5").Select ' This is the problem Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True Range("A1:A3").Copy Range("C6").Select ' This is the problem Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with vba script | New Users to Excel | |||
Script Help? | Excel Programming | |||
Excel 2000/XP script to Excel97 script | Excel Programming | |||
VB Script help | Excel Programming |