Results 1 to 13 of 13

Control down with Macro

Threaded View

feejo Control down with Macro 10-09-2007, 01:02 PM
VBA Noob Is this what your after ... 10-09-2007, 01:09 PM
feejo Ok I change my script, so it... 10-09-2007, 01:40 PM
VBA Noob See if link helps ... 10-09-2007, 01:52 PM
royUK Why do you have so many... 10-10-2007, 02:43 AM
  1. #1
    Forum Contributor
    Join Date
    05-18-2007
    Posts
    153

    Control down with Macro

    I record a macro that copy a portion of a tab to another, but when my data changes the destination get data one above the other. I think it is because instead of sending Control Donw it goes to the cell that I recorded the macro with.

    I probably just need to send Control downkey.

    PHP Code: 
    Range("C22:E22").Select
        Range
    (SelectionSelection.End(xlDown)).Select
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        Sheets
    .Add
        Range
    ("A2").Select
        ActiveSheet
    .Paste
        Windows
    ("T&S2 5X 2000.xls").Activate
        ActiveWindow
    .ScrollRow 1
        Range
    ("K8:M19").Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        Range
    ("D2").Select
        Selection
    .PasteSpecial Paste:=xlPasteValuesOperation:=xlNoneSkipBlanks _
            
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteFormatsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteCommentsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Range
    ("A11").Select
        Selection
    .End(xlDown).Select
        Range
    ("A190").Select
        Windows
    ("T&S2 5X 2000.xls").Activate
        Sheets
    ("TS-3").Select
        Range
    ("C22:E22").Select
        Range
    (SelectionSelection.End(xlDown)).Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        ActiveSheet
    .Paste
        Range
    ("D190").Select
        Windows
    ("T&S2 5X 2000.xls").Activate
        Range
    ("K8:M19").Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        Selection
    .PasteSpecial Paste:=xlPasteValuesOperation:=xlNoneSkipBlanks _
            
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteFormatsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteCommentsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Windows
    ("T&S2 5X 2000.xls").Activate
        Sheets
    ("TS-2").Select
        Range
    ("C22").Select
        Selection
    .End(xlToRight).Select
        Selection
    .End(xlToRight).Select
        Range
    ("C22:E22").Select
        Range
    (SelectionSelection.End(xlDown)).Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        Range
    ("A190").Select
        Selection
    .End(xlDown).Select
        Range
    ("A216").Select
        ActiveSheet
    .Paste
        Range
    ("D216").Select
        Windows
    ("T&S2 5X 2000.xls").Activate
        Range
    ("G40").Select
        Selection
    .End(xlUp).Select
        Range
    ("K8:M19").Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        Selection
    .PasteSpecial Paste:=xlPasteValuesOperation:=xlNoneSkipBlanks _
            
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteFormatsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteCommentsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Range
    ("A216").Select
        Selection
    .End(xlDown).Select
        Range
    ("A245").Select
        Windows
    ("T&S2 5X 2000.xls").Activate
        Sheets
    ("TS-1").Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        Range
    ("D245").Select
        Selection
    .PasteSpecial Paste:=xlPasteValuesOperation:=xlNoneSkipBlanks _
            
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteFormatsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteCommentsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Range
    ("A245").Select
        Windows
    ("T&S2 5X 2000.xls").Activate
        Range
    ("C22:E22").Select
        Range
    (SelectionSelection.End(xlDown)).Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        ActiveSheet
    .Paste
        Windows
    ("T&S2 5X 2000.xls").Activate
        Sheets
    ("T&S Today").Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        Selection
    .End(xlDown).Select
        Range
    ("D295").Select
        Selection
    .PasteSpecial Paste:=xlPasteValuesOperation:=xlNoneSkipBlanks _
            
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteFormatsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Selection
    .PasteSpecial Paste:=xlPasteCommentsOperation:=xlNone_
            SkipBlanks
    :=FalseTranspose:=False
        Range
    ("A295").Select
        Windows
    ("T&S2 5X 2000.xls").Activate
        Range
    ("C22:E22").Select
        Range
    (SelectionSelection.End(xlDown)).Select
        Application
    .CutCopyMode False
        Selection
    .Copy
        Windows
    ("archive.xls").Activate
        ActiveSheet
    .Paste
        Selection
    .End(xlDown).Select
        Range
    ("A308").Select
        Windows
    ("T&S2 5X 2000.xls").Activate
        Windows
    ("archive.xls").Activate
        Selection
    .End(xlUp).Select
        Selection
    .End(xlUp).Select
        Range
    ("A294").Select
        Application
    .CutCopyMode False
        ActiveCell
    .FormulaR1C1 "10/6/2007"
        
    Range("A295").Select
    End Sub 
    Last edited by VBA Noob; 10-09-2007 at 01:05 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1