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: 100
Default Adding watch point "Application.Caller" crashes Edsel 97.

As a Delphi programmer, I'm sincerely trying to adapt to VBA, I really
am.

But, I've got this workbook. I work on it in various versions of
Excel, but right now it's Excel 97 SR2.

First, I set a break point on the first line of code in a function I
wrote. The function is called by referencing it in a cell. E.g., cell
A1 contains "=MyUDF(xxx)".

If I edit cell A1, then exit editing mode, focus jumps to the VBA
environment with execution paused on my break point. Fine. Next I add
a watch point.

If I add, say, watch expression "Application", then, as lovable
Hungarian character actor S. Z. Sakall said in "Christmas in
Connecticut" (1945), "Ev'rysing is hunky-dunky".

But if I so much as add an expression beginning with
"Application.Caller", e.g. "Application.Caller",
"Application.Caller.Address" or something like that, it's Bombs Away
for Excel 1897.

(And if you saw my other recent post, you know I'm having to do my
work amid Excel 97's crashing every time two or more merged cells
happen to show up on row 2841. No joking.)

So, I mean, what's y'all's opinion? Is Excel VBA a stable product, or
is it ... an EDSEL?

Thanks.

***
 
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
Adding data only if adjacent to cell labeled "male"/"female" lovesrubbaducky Excel Worksheet Functions 1 November 23rd 09 05:49 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
=SUM((C2:C7000="Friday")*(F2:F7000="8:00:00 AM")) not adding chubbybat Excel Discussion (Misc queries) 9 March 5th 08 01:40 PM
Macro crashes "Automation error" during copy of workbook with char Yorch Excel Programming 0 January 30th 06 09:09 PM
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc Bob Reynolds[_2_] Excel Programming 0 March 4th 04 08:52 PM


All times are GMT +1. The time now is 05:08 AM.

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"