Results 1 to 28 of 28

Error Message (Compile Error, Procedure too Large)

Threaded View

dreicer_Jarr Error Message (Compile Error,... 05-20-2009, 02:58 PM
stanleydgromjr Re: Error Message (Compile... 05-20-2009, 05:15 PM
shg Re: Error Message (Compile... 05-20-2009, 06:52 PM
dreicer_Jarr Re: Error Message (Compile... 05-20-2009, 08:20 PM
shg Re: Error Message (Compile... 05-20-2009, 08:51 PM
dreicer_Jarr Re: Error Message (Compile... 05-20-2009, 09:38 PM
shg Re: Error Message (Compile... 05-20-2009, 09:52 PM
dreicer_Jarr Re: Error Message (Compile... 05-20-2009, 10:14 PM
Phil_V Re: Error Message (Compile... 05-21-2009, 04:18 AM
dreicer_Jarr Re: Error Message (Compile... 05-21-2009, 06:39 AM
dreicer_Jarr Re: Error Message (Compile... 05-21-2009, 06:55 AM
dreicer_Jarr Re: Error Message (Compile... 05-21-2009, 06:58 AM
stanleydgromjr Re: Error Message (Compile... 05-21-2009, 08:56 AM
Phil_V Re: Error Message (Compile... 05-21-2009, 09:02 AM
Phil_V Re: Error Message (Compile... 05-21-2009, 04:50 AM
Phil_V Re: Error Message (Compile... 05-21-2009, 06:51 AM
Phil_V Re: Error Message (Compile... 05-21-2009, 08:23 AM
dreicer_Jarr Re: Error Message (Compile... 05-21-2009, 09:23 AM
dreicer_Jarr Re: Error Message (Compile... 05-21-2009, 09:26 AM
Phil_V Re: Error Message (Compile... 05-21-2009, 10:25 AM
fmunirah2 Re: Error Message (Compile... 10-29-2010, 02:08 AM
romperstomper Re: Error Message (Compile... 10-29-2010, 03:52 AM
  1. #1
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Error Message (Compile Error, Procedure too Large)

    I am looking for a more efficient way to write a macro (a sample from the macro is below). This is just the first part of the macro. I need to repeat these same steps (seen for row 5 below) for rows 5 to 50. My script worked until I hit row 35 and then I got the "compile error.." message. There must be a way to use "loop" to write this more efficiently, no?

    If Range("M5") = 1 Then
        
        Worksheets("ICON").Select
        Worksheets("ICON").Shapes("Picture 5").Copy
        Range("A1").Select
        Worksheets("dashboard").Select
        Range("H5").Select
        ActiveSheet.Paste
        Range("A1").Select
        End If
        
        If Range("M5") = 2 Then
        
        Worksheets("ICON").Select
        Worksheets("ICON").Shapes("Picture 6").Copy
        Range("A1").Select
        Worksheets("dashboard").Select
        Range("H5").Select
        ActiveSheet.Paste
        Range("A1").Select
        End If
        
        If Range("M5") = 3 Then
        
        Worksheets("ICON").Select
        Worksheets("ICON").Shapes("Picture 7").Copy
        Range("A1").Select
        Worksheets("dashboard").Select
        Range("H5").Select
        ActiveSheet.Paste
        Range("A1").Select
        End If
        
        Range("A1").Select
        
        If Range("N5") = 1 Then
        
        Worksheets("ICON").Select
        Worksheets("ICON").Shapes("Picture 8").Copy
        Range("A1").Select
        Worksheets("dashboard").Select
        Range("I5").Select
        ActiveSheet.Paste
        Range("A1").Select
        End If
        
        If Range("N5") = 2 Then
        
        Worksheets("ICON").Select
        Worksheets("ICON").Shapes("Picture 9").Copy
        Range("A1").Select
        Worksheets("dashboard").Select
        Range("I5").Select
        ActiveSheet.Paste
        Range("A1").Select
        End If
        
        If Range("N5") = 3 Then
        
        Worksheets("ICON").Select
        Worksheets("ICON").Shapes("Picture 10").Copy
        Range("A1").Select
        Worksheets("dashboard").Select
        Range("I5").Select
        ActiveSheet.Paste
        Range("A1").Select
        End If
    Last edited by dreicer_Jarr; 05-21-2009 at 09:29 AM. Reason: Adding code tags

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