View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Alok Alok is offline
external usenet poster
 
Posts: 318
Default function "compile error msg: procedure too large"

Hi Rashesh,

Try exporting the modules, deleting them, then re-importing. That sometimes
helps.

Alok Joshi

"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