View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 195
Default 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