On Sep 8, 8:47*am, "Rick Rothstein"
wrote:
I'm only guessing here...

Let me address your second question first... the Proper function returns a
(string) value... if you fed it an array, where would the elements of the
array go (keeping in mind that a worksheet function can only affect the
contents of the cell the formula is in)?

As for your first question... whatever the underlying worksheet array
processing functionality is, it treats arrays as ranges and a range cannot
have a 0 row or a 0 column, so it would appear the array (range) produced
would necessarily have to be 1-based.

Let me repeat my opening statement... I am only guessing here.

--
Rick (MVP - Excel)

"Peter T" <peter_t@discussions wrote in message

...



Even with Option Base 0 the array returned from the Proper function is 1
base.

Any ideas why Proper can process an array as an Application function, but
not as a Worksheet function.

Regards,
Peter T

"Rick Rothstein" wrote in message
...
Dim arr, arrP
arr = Array("AAA", "BBB", "CCC")
arrP = Application.Proper(arr)

bounds of arr are 0 to 2 but arrP is 1 to 3

The bounds for the array that the Array function creates take their cue
from the Option Base... without an Option Base statement, or with an
Option Base 0 statement, the bounds are as you stated (0 to 2); however,
if Option Base 1 is specified, then the bounds will be 1 to 3. This is
different than the array that the Split function produces... the Split
function *always* creates zero-based arrays no matter what the Option
Base setting is.

--
Rick (MVP - Excel)- Hide quoted text -

- Show quoted text -

Thanks everyone, the answers worked a treat.

Kind Regards,
Paul