Help with data validation loop - Inputting formulas throws errors

**charliew001** · 06-23-2014, 06:26 PM

Essentially, the code below is supposed to select all cells between k2:k76 and do a data validation list with this formula as the source:

Please Login or Register  to view this content.

This is to allow for dependent validation (k2 validation corresponds to whatever the chosen value in j2, and so on). However, every time I try running the script, VB is giving me a "Application-defined or object-defined error." What is stranger is I recorded a macro of me inputting that source for a datavalidation list in excel. The macro works fine, but after I try running my script, the macro, which was previously working, no longer works. Any advice is appreciated.

Please Login or Register  to view this content.

**natefarm** · 06-24-2014, 12:19 PM

When it gives the error, click Debug, which will put you in the code with the current line highlighted. Hover over variables to see where it is in the process, and maybe you can figure it out.

**charliew001** · 06-24-2014, 02:00 PM

OK, I figured it out. It was kind of a oversight on my part. The contents of the data validation cell in J$2$ cannot be empty, otherwise VBA throws an Object-defined error. If I attempted to input the dependent validation in K$2$, excel would throw me an error dialogue box but still proceed.