View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Empty keyword in statment Application.caption?

Personally, I have found little in the help to indicate that "empty" is a
key word.

If empty isn't declared as a variable or is declared as Variant and never
initialized, then it would represent the value of an uninitialized variable.
Used in the context you show, it would be equivalent to a null string, so it
does nothing that I can see.

--
Regards,
Tom Ogilvy


"Mel" wrote in message
...
I was trying to learn from some code someone else had
written. What is the keyword Empty used for in the
statement below. If I remove the "Empty &" the results
seem to be the same. Is it just a placeholder of some
kind?


Application.Caption = empty & "Microsoft Excel (Alarm Set
for "

Application.Caption = "Microsoft Excel (Alarm Set for "