I am looking for a way to find the address of the data used to create a dropdown in vba. The dropdown is created by using the code :
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
Operator:=xlBetween, Formula1:="='" & ws.Name & "'!" & range1.Address
the dropdown code is used multiple time and I need to find a way to find the worksheet used for the formula1 code. This will help me be able to create cases that reference that worksheet later on in my code. please see picture attached:
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
Operator:=xlBetween, Formula1:="='" & ws.Name & "'!" & range1.Address
the dropdown code is used multiple time and I need to find a way to find the worksheet used for the formula1 code. This will help me be able to create cases that reference that worksheet later on in my code. please see picture attached: