Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiler Going Flaky on Me
Hi Steve,
To obtain meaninful assistance, I suspect that you will need to post the problematic code, indicating where the error is encountered. --- Regards, Norman "Steve Drenker" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiler Going Flaky on Me
I suggest Rob Bovey's Code Cleaner if you havn't already:
http://www.appspro.com/Utilities/Utilities.htm Regards, Greg "Steve Drenker" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiler Going Flaky on Me
One thing that won't solve your problem, but may make it easier to debug,
would be to put each SUB or UDF or whatever into its own module. Sometimes that makes it easier to understand where the errors are coming from. Good luck. Bill ----------------------------- On Wed, 08 Mar 2006 02:06:55 GMT, Steve Drenker wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getpivotdata behaving flaky | Excel Worksheet Functions | |||
Excel Compiler | Excel Discussion (Misc queries) | |||
Flaky combo boxes. Work around? | Excel Programming | |||
Flaky combo boxes. Work around? | Excel Programming | |||
Flaky Input Box | Excel Programming |