Forum Discussion
OriolFM
Mar 13, 2023Copper Contributor
Cells with data validation on a table will autoapply the same data validation to the headers
I have a big table with some columns that have data validation applied, to restrict the options in case someone edits the table manually. I started using Excel VBA and Excel Forms to handle the d...
JKPieterse
Mar 13, 2023Silver Contributor
This:
ListObject.ListRows(row).Range
includes the heading cell. Use this instead:
ListObject.ListRows(row).DataBodyRange
ListObject.ListRows(row).Range
includes the heading cell. Use this instead:
ListObject.ListRows(row).DataBodyRange
- HansVogelaarMar 13, 2023MVP
Hi Jan Karel, a ListColumn has a header cell, but a ListRow doesn't...
- JKPieterseMar 13, 2023Silver ContributorHansVogelaar Hahahaha I think it is time to close shop and go home for the day 🙂