I have a few drop down lists on my worksheet. I use right-click, insert to add new rows. How do I get the validation to display on the newly inserted row? I have the sheet formatted as a table.
Thanks
I have a few drop down lists on my worksheet. I use right-click, insert to add new rows. How do I get the validation to display on the newly inserted row? I have the sheet formatted as a table.
Thanks
If your Data is formatted as a Table with Data Validation Lists in certain cells, as soon as a new row is inserted, the Validations should automatically be available on the newly inserted rows.
Cheers!
Deep Dave
If you insert new rows inside the table/range, you will need to add the DD's manually, otherwise, use a Table, add the new data at the end and read post #2
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks