Ubound and Lbound

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you use Ubound and Lbound in the Expression Builder? If possible can
you list some examples?

Thanks for your help,

Cage
 
LBound() and UBound() apply to arrays.
Arrays are used in code.
They are not very useful in expressions in text boxes or query fields.

There's a practical example of using UBound() in code here:
http://allenbrowne.com/func-10.html
The code parses a phrase into an array of words, and loops through the array
to return the n-th word.
 
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

If value occurs more than once then delete all of them 8
Variant Array Copy, Array row contains Object 3
Search an array of sheets for an array of numbers & return count of numbers 11
Help! I can no longer use =Date() as the Default Value on my Forms 3
Too much data for this code? 4
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Make VBA ComboBox_Change work in 3 sheets 1
LBound and UBound question 2

Back
Top