Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    Boston
    Posts
    8

    Unanswered: Continue BV script...

    I have some VB I want to repeate ...how do I go about this...It is for Excel to basically calculate the next row and so on.....

    Range("H2").Select
    Selection.Copy
    Windows("AAP_FIP_Calc_MACRO.xls").Activate
    ActiveWindow.LargeScroll Down:=-1
    Range("B5").Select
    ActiveSheet.Paste
    Windows("MPO YTD 032603.xls").Activate
    Range("G2").Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("AAP_FIP_Calc_MACRO.xls").Activate
    Range("B12").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = "=157731/12"
    Range("C8").Select
    Selection.Copy
    Windows("MPO YTD 032603.xls").Activate
    Range("K2").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    End Sub

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: Continue BV script...

    help us help you, whats exactly you wanna do

Posting Permissions

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