picking cell from named range passed to vba

**toddah** · 07-27-2011, 02:31 PM

I'm trying to pull data from different rows of 2nd and 3rd column based on two passed values I am matching in the first column. the match seems to work fine, but getting the corresponsing values out of the named range isn't. thoughts on what i'm doing wrong?

One of the relevant lines is here:
vol_percent = curves.Cells(vol_pointer - 1 + i, 2).Value

The code for this entire array function follows:

Please Login or Register  to view this content.

**Leith Ross** · 07-27-2011, 04:30 PM

Hello toddah,

Welcome to the Forum!

You code assumes the range passed into the function has at least 3 columns. Yet, you have no code to validate the incoming range's size in rows and columns. If you range comes up short in either rows or columns, you are going to have problems.

**toddah** · 07-27-2011, 09:48 PM

Thanks Leith,

Good point about ensuring range is the correct size. In the call I'm passing a named range that is 50 rows by 3 columns. The matches are returning the correct row numbers. The curve.cells return empty even though there is good data in columns 2 and 3 corresponding to the match row. Is there something wrong with this syntax?
vol_percent = curves.Cells(vol_pointer - 1 + i, 2).Value

Cheers,
-Todd

**Leith Ross** · 07-27-2011, 11:49 PM

Hello Todd,

I don't see anything obvious. It would be easier to troubleshoot if you could post a copy of the workbook. Please remove or change any information of a personal nature or what your company might consider to be confidential. If you need to scale down the workbook then it should be faithful to original in data layout, formulas, and any VBA code. Please include before and after examples of the data along with any explanatory comments.