Finding LBound & UBound of 2D Arrays

**Mordred** · 06-09-2011, 11:11 AM

Hi all,

I just cannot seem to get my logic straight. How can I find the lower and upper bounds of a 2D array? I cannot just go with

x = LBound(2DArray) To UBound(2DArray)

Any ideas?

Regards:

**romperstomper** · 06-09-2011, 11:17 AM

For x = LBound(2DArray, 1) To UBound(2DArray, 1)
   for y = LBound(2DArray, 2) To UBound(2DArray, 2)

**Mordred** · 06-09-2011, 11:21 AM

Thanks romperstomper for that, it hit the spot!

**MickG** · 06-09-2011, 11:22 AM

Try:-

Dim Ray
Ray = Range("A1:F10").value
MsgBox LBound(Ray, 1) 'First row
MsgBox UBound(Ray, 1) 'Last Row
MsgBox LBound(Ray, 2) 'First column
MsgBox UBound(Ray, 2) 'Last column

Finding LBound & UBound of 2D Arrays

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Finding LBound & UBound of 2D Arrays

Re: Finding LBound & UBound of 2D Arrays

Re: Finding LBound & UBound of 2D Arrays

Re: Finding LBound & UBound of 2D Arrays

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions