Hi,
I have a question related to using Data Validation to make Dependant Lists, ie. lists that vary depending on selections made from another list.
I have this working when I use definite range name references ie. List1 =Sheet1!$A$2:$A$5 List2 =Sheet1!$B$2:$B$4 and so on. However if I wish to use the Offest function to define the range name so that I can add to the lists without having to re-define the range names [ie. List1 =OFFSET($A$1,1,0,counta($A:$A)-1,1)], the data validation no longer works.
I am self taught in Excel and am only just starting to play with VBA, so would greatly appreciate any help you are able to offer.
Thanks in advance,
Flemingo.
I have a question related to using Data Validation to make Dependant Lists, ie. lists that vary depending on selections made from another list.
I have this working when I use definite range name references ie. List1 =Sheet1!$A$2:$A$5 List2 =Sheet1!$B$2:$B$4 and so on. However if I wish to use the Offest function to define the range name so that I can add to the lists without having to re-define the range names [ie. List1 =OFFSET($A$1,1,0,counta($A:$A)-1,1)], the data validation no longer works.
I am self taught in Excel and am only just starting to play with VBA, so would greatly appreciate any help you are able to offer.
Thanks in advance,
Flemingo.
