Hi all,
I've found similar questions to mine in multiple posts on multiple sites to solve this issue; unfortunately, none of the solutions have worked for me. I'm trying to create a block of code that will create a new data validation every time I run the code. The validation part of my code (which is part of a larger macro) is as follows:
Notes:
1.Tables is a different worksheet where dates have already been added in the following format (with each item in its own cell): No 2016 2017 2018 2019
2.table_Row has already been defined as the row that contains the horizontal list I want to reference for the validation (I've used this variable in other parts of the code, so I'm pretty sure this isn't the problem)
3. iss_Col-1 refers to the column that will include the "No" in note 1. above. This was defined as an integer variable. (again, this variable has been used, so the problem isn't here)
4. mat_Col refers to the column that will include the "2019" in note 1. above. This was defined as an integer variable. (again, this variable has been used, so the problem isn't here)
5. The error I get is either a run-time error 13 or 1004 (changes depending on the changes I make based on suggestions from similar forums)
6. I can't absolute reference any of the cells or ranges above, because there will be a new validation for each new row added.
I can possibly post more code but can't release the whole workbook, because the information is proprietary.
Thanks!
Kyle
Bookmarks