$$Excel-Macros$$ What is UBOUND and L Bound In VBA (Excel Macros)

Hi Everyone. Can Someone explain About Ubound and Lbound in Excel VBA with Example. Or sending some attached sheet. Thanks and Regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ What is UBOUND and L Bound In VBA (Excel Macros)

HI, The largest available subscript for the indicated dimension of an array can be obtained by using theUbound function. In our one-dimensional array example, Ubound(arr) is 5. In our two-dimensional array example above, there are two upper bound figures - both are 2. UBound returns the