Stjernemix
New Member
- Joined
- Nov 28, 2020
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
I have a range of validation lists that needs to be reset to their first value (its a text string not numerical value).
Imagine if the validation lists in the range can be set to any number from 0-20 then you could reset it by the following simple macro:
Sub X()
Range("G16:G22").Value = "0"
End Sub
But in a range of validation lists where the first choice is not the same the above simple macro does not work, also it is text not numbers.
Also some cells in the range does not contain a validation list and is just a normal cell with text.
How can I make a macro that resets the range to the first selection in all the validation lists in the range, while I still have some none validation cells ?
Imagine if the validation lists in the range can be set to any number from 0-20 then you could reset it by the following simple macro:
Sub X()
Range("G16:G22").Value = "0"
End Sub
But in a range of validation lists where the first choice is not the same the above simple macro does not work, also it is text not numbers.
Also some cells in the range does not contain a validation list and is just a normal cell with text.
How can I make a macro that resets the range to the first selection in all the validation lists in the range, while I still have some none validation cells ?