Procedure too large

**theresap** · 07-13-2010, 03:13 PM

I have tried various methods to accomplish this. This procedure works, unfortunately when I copy it for the remaining 27 worksheets I get the error Compile error : Procedure too large.
Can you help me make this smaller.

Please Login or Register  to view this content.

Thank you!

**snb** · 07-13-2010, 03:25 PM

to do the same thing in 1 line:

Please Login or Register  to view this content.

**theresap** · 07-13-2010, 03:35 PM

I replaced my code with yours and get
run-time error '13": Type mismatch

**royUK** · 07-13-2010, 04:03 PM

You don't need the code in every sheet,place it in a Standard Module. I've started editing it to make it more efficient,you can continue

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:

Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

**snb** · 07-14-2010, 03:33 AM

From this distance I can't see what's in you sheet.
You didn't even provide an example file.
Solving errors is a local activity that can only be done in an existing (not an imaginary) sheet.

**theresap** · 07-14-2010, 01:40 PM

Thank you RoyUK. It worked perfectly. Down to 44k.

**royUK** · 07-14-2010, 02:54 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save