Split Function ALWAYS base zero?

  • Thread starter Thread starter Paul Overway
  • Start date Start date
P

Paul Overway

Yes...the array is zero based (see help). Nevertheless, you just need to
subtract 1 from the index you're using...not that difficult.
 
It appears from debugging that the Split function returns
a "zero-based" array EVEN if Option Base 1 is specified.
Is that correct? If so, it sure screws things up if a Split
function is added to code that is already peppered with
code that is already using "1" based indexing.
Bill
 
Yes, I'd seen what Help had to say. It's just inconsistent with
what Array Help had to say about the use of Option Base 1
with arrays in general, so I thought I'd ask anyway.
Thanks,
Bill
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Option Base 1 2
this is killing me. INDEX/MATCH "closest to X" in a smart way? 5
Split() order into array 2
NumberFormat for small non-zero numbers? 2
Displaying zeros in cells 2
VBA Multiple Line handling with Split() 1
Can someone translate this doc snippet to English...? 2
How to assign Spit to 1-origined array? 5

Back
Top