VBA to create Data Validation (including Offset and Match)

Hello All,

I am trying to have data validation included in my macro which formats and enters formulas in cells.

The problem seems to be that I have a data validation formula that isn't simply refering to a dynamic range.
Here is the formula:

Please Login or Register  to view this content.

This works great in the list data validation.

But now I want to put it into my formatting macro which also adds the list data validation.

I don't know how to make the "B1" dynamic so it always looks in column B but in current row. I tried recording the macro and got this:

Please Login or Register  to view this content.

I then tried to change the "B1" to RC2....but it errored out.

Any ideas or places I should look?

Thanks,
Matt

Thanks for the suggestions.

Norie - I use a German excel version, we use ";" instead of ","...I know my status says Portland, but I am currently living in Germany for a while. My bad for not updating my profile, sorry.

Hi again JosephP - I tried your suggestion and get an application-defined or object-defined error ('1004').

I would think this is pretty straight forward....puzzling.

Other ideas?

Thanks,
Matt

I am open to anything! :-)

I gave it a try, same error. This is my exact code:

Please Login or Register  to view this content.

For simplicity in the thread, I replaced "CustFab_Customer_Group_CLStart" with "NamedRange1" and "CustFab_Customer_Group_CL" with "NamedRange2"....but that shouldn't make a difference if it works in the list data validation directly...right?

Thanks,
Matt