Posted to microsoft.public.excel.programming

David

external usenet poster

Posts: 195

Application.WorksheetFunction.Upper

Chip Pearson wrote

UCase$ (and all string related functions that end in '$') returns a
String type result, while UCase (and string related functions that do
not end in '$') return Variant data types. The '$' functions are more
efficient because the compiler does not need to emit instructions to
extract the string data out of the Variant.

Thanks for the explanation.

--
David

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Reuse Application.WorksheetFunction	jlclyde	Excel Discussion (Misc queries)	4	March 12th 09 08:32 PM
Application.WorksheetFunction error	Ayo	Excel Discussion (Misc queries)	4	May 16th 08 05:04 PM
Need help with Application.WorksheetFunction	Ayo	Excel Discussion (Misc queries)	4	May 14th 08 11:13 PM
application.worksheetfunction.mmult help	Alex[_13_]	Excel Programming	2	October 29th 03 10:13 PM
Using Application.WorksheetFunction.Ln(...) in VBA	doco	Excel Programming	4	August 25th 03 01:08 PM

All times are GMT +1. The time now is 10:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us