424 Object Required error when referencing an array in a UDF

[hadamhiram]

EDIT: solved. The error comes from adding .Value on the end ... deleted, and works fine.


I'm a total VBA noob, and have close to zero programming skills. Can anyone explain why I'm getting a 424 Object Required error on the first line where I try to use an array after I've defined it?

Here's where I define the array:

MyArray = Range("A" & (FirstRow) & ":B" & (LastRow)).Value

and here's the line that the code bugs out on:

MyVar = Analytic_Array(1, 1).Value

I just can't figure out why this isn't working! Anybody have any idea what I'm doing wrong?

[AlvaroSiza]

Unfortunately, you will need to provide a good bit more information in order for anyone to understand what's really going on. For example, your post does not speak to what MyVar and Analytic_Array are and how they were created. The array (MyArray) you defined is not referenced at all in the line of code claimed as the bug out culprit.

I would suggest expanding on your problem, post code (using code tags) and possibly posting a sample workbook. This will greatly increase the chance that you have a successful solution developed.

BTW - "VBA noob, close to zero programming" does not exactly translate well to array development, manipulation, and analysis. In other words, were VBA to be a class, arrays would be discussed in the 2nd half for sure. I would encourage you to get a good handle on the basics if you continue to pursue.