LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Compiler Going Flaky on Me

Aarrgh!!

I'm starting to get some real compiler weirdness going on that has me
concerned.

I was writing a UDF and started getting "Compile Error: Only comments may
appear after End Sub, End Function, or End Property".

The only thing after "End Function" was a couple of more subs.

I took out the offending UDF and began piecing it together by writing
line-by-line fresh into the Module.

Things were looking promising, but then all at once the compiler gave me an
error on the PRECEDING function (previously debugged and working well)
saying "Expected End Function." This error point was about three lines
before the existing "End Function."

Is my project totally hosed? How to stop this behavior?

The spreadsheet is about 1.3 MB in size now. Running Mac Powerbook G4, 2 GB
RAM, Office / Excel 2004.

Also, I recently upgraded my machine from 512 MB to 2 GB RAM. I have had two
crashes that appear RAM-related. Not getting kernel panic, but the whole
machine crashes and I get some low-level messages in white letters on black
background overlaid on the previous display image. This has happened twice.
Haven't run TechTools yet to check the RAM. Will do later tonight.

Hellppp!!!

Steve

 
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
Getpivotdata behaving flaky conniemm Excel Worksheet Functions 0 September 15th 07 12:06 AM
Excel Compiler Steve-in-austin Excel Discussion (Misc queries) 2 June 8th 06 06:44 PM
Flaky combo boxes. Work around? rjamison Excel Programming 0 June 14th 05 12:14 AM
Flaky combo boxes. Work around? Don Wiss Excel Programming 1 April 20th 05 02:44 PM
Flaky Input Box Andrei Scudder Excel Programming 0 September 22nd 03 11:39 PM


All times are GMT +1. The time now is 02:19 PM.

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"