jongooligan
Board Regular
- Joined
- Jul 23, 2007
- Messages
- 90
Trying to use a dynamic range to validate cells on an input sheet using list = SomeName where SomeName is derived from this formula
=OFFSET(BB!$G$1,0,0,COUNTA(BB!P:P),1)
BB is a sheet that stores various named lists
When I try to validate the cells Excel returns "the source currently evaluates to an error"
There's no help available from the msgbox so can someone here help please?
BTW - if I try to validate any cells on the input sheet Excel will not allow me to select any other sheet tab.
=OFFSET(BB!$G$1,0,0,COUNTA(BB!P:P),1)
BB is a sheet that stores various named lists
When I try to validate the cells Excel returns "the source currently evaluates to an error"
There's no help available from the msgbox so can someone here help please?
BTW - if I try to validate any cells on the input sheet Excel will not allow me to select any other sheet tab.