LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 703
Default function "compile error msg: procedure too large"

Hi Rashesh,

First of all, please turn off your Caps Lock. Thanks. Well, I've never
seen that compiler error. I didn't know there was a size limit, but
typically it's good practice to break up large routines into smaller
functional units. Have you tried breaking up your procedure into pieces such
as one sub to create the sheet, one to open and read database info, one to
move data into the sheet, one to reformat cells, etc. Try that.


"RASHESH" wrote:

HI,

CAN ANYONE HELP ME!!!

I AM WRITING IN OFFICE XP EXCEL VBA FUNCTION, THIS FUNCTION IS DOING CREATE A ONE SHEET AND IMPORT FROM dBASE IV DBF FILE INTO EXCEL AND PARTICULAR SHEET FORMAT AND I AM CHANGING FONTS, ROW HEIGHT, CELL LOCK PROPERTY, COLUMN WIDTH, CELL NUMBERS FORMAT AND ETC. THIS ALL LINE ARE WRITE. THIS FUNCTION TOTAL LINES ARE 1125. IN MY CODE I CHEK EVERY LINES BUT NO ERRORS.

PC CONFIGURE
----------------
WINDOWS XP
OFFICE XP
P4 1.5GHZ
512 BUS RAM
60GB HDD (10GB FREE)

REGARDS
RASHESH

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Compile error: Procedure too large? Jerry Dyben Excel Discussion (Misc queries) 1 October 31st 05 10:15 PM
Procedure too large" error ...DAMN -[::::Shamran::::]- Excel Programming 5 April 5th 05 10:47 PM
Compile Error: Procedure too large mate Excel Programming 2 May 18th 04 04:30 PM
Getting "compile error" "method or data member not found" on reinstall Bp Excel Programming 1 April 23rd 04 04:42 PM
the "Procedure too large" error abxy[_57_] Excel Programming 1 April 22nd 04 03:16 AM


All times are GMT +1. The time now is 09:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"