Results 1 to 20 of 21

Thread: Problem with macro

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Mentor
    Joined
    Aug 2011
    Posts
    353
    Location

    Problem with macro

    There is a problem with the highlighted line. I have tried to alter this but can't figure it out. Can you tell what is wrong?

    Sub CopyandPaste()
        Dim LastRow As Long
        With ActiveSheet
            .Range("A2:H2").Resize(.Range("A2").End(xlDown).Row - 1).Copy
        End With
        Windows("Broker Volume Master.xlsx").Activate
        Application.Run "BLPLinkReset"
        With ActiveSheet
            LastRow = .Range("A2").End(xlDown).Row
            .Cells("A", LastRow + 1).Paste
        End With
    End Sub
    thanks for helping!
    Last edited by Aussiebear; 06-17-2025 at 07:16 PM.

Posting Permissions

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