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