Code to refer to Dynamic Range

[philozelda]

hey guys - I put together a quick set of code to search for a selected value and return a sumif value for the selected value. Instead of referring to the range explicitly, I'd like to refer to a named range that I created.

Here is the code:

Please Login or Register  to view this content.

In place of range("M2:M766"), I'd like to refer to a named range I created called Check_nbr1 and for range("O2:O766"), I'd like to refer to a named range called Paid_Amt. I tried to do that in the code but it errored: Run-time error 1004': Method 'Range' of object '_Global' failed. I'm guess it can't be done this way?

[Leith Ross]

Hello philozelda,

Did you try this?

Please Login or Register  to view this content.