Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |