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
|