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 following values for an array with these dimensions*: Dim A(1 To 100, 0 To 3, -3 To 4) Statement Return Value UBound(A, 1) 100 UBound(A, 2) 3 UBound(A, 3) 4 * Example taken from Excel VBA Help section. The UBound function is used with the LBound function to determine the size of an array. Use theLBound function to find the lower limit of an array dimension. Statement Return Value LBound(A, 1) 1 LBound(A, 2) 0 LBound(A, 3) -3 To get the size of an array, use the following formula: UBound(Arr) - LBound(Arr) + 1 For example: Ubound(A,1) - LBound(A,1) + 1 = 100 - 1 + 1 = 100 Ubound(A,2) - LBound(A,2) + 1 = 3 - 0 + 1 = 4 Ubound(A,3) - LBound(A,3) + 1 = 4 - (-3) + 1 = 8 For more details please visit http://www.anthony-vba.kefra.com/vba/vbabasic3.htm <http://www.anthony-vba.kefra.com/vba/vbabasic3.htm>Cheers Andy On Sun, Sep 5, 2010 at 12:53 PM, bhavya khanna <bhavya...@gmail.com> wrote: > 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 tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe