Excel Macro Stops Running

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

maggabones

Thread Starter
Joined
Oct 28, 2011
Messages
1
My macro stops running and there is no error msg. My macro basically copies formulas contained in 5 cells from one spreadsheet to another but the macro just stops running after it pastes the data. No error msg. I've tried running the macro step by step and it stops running at the exact same place. If I either run the macro again or keep pressing F8, the macro begins again from the start of the sub procedure and runs completely (doesn't stop). I don't understand why it's stopping the first time I run the macro.

Here is the code:

Code:
    Windows("Fund Dilution Macro.xls").Activate
    Range("O5:S5").Select
    Selection.Copy
    Windows("NAVDILAC.USR").Activate
    Range("O5").Select
    [B][SIZE=4][COLOR=red]ActiveSheet.Paste[/COLOR][/SIZE][/B]
    Application.CutCopyMode = False
    Selection.Copy
    Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
    ActiveSheet.Paste
After the macro pastes the data from the first spreadsheet, it just stops running. When I am running through the macro step by step (using F8), the yellow right arrow that you usually see on the left hand side of the row of code that is running just disappears after the "ActiveSheet.Paste" line (highlighted in red above).
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
Hi, wlecome to the forum,
I imagine this is not all of the macro but there are no further actions here and I can't see what else follows
What is Naddilac.usr? well not much to say with this info.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top