I think if you record a macro when you do it manually, you'll see what you
need. And you'll have the worksheet names, range names, and cells correct for
your project.


PW11111 wrote:

Hi,

Does anyone know how to define a validation with VB?

I have a number of named ranges (on a hidden validation sheet) that make up
drop downs in my spreadsheet - I'd like to set these up from within a Macro.

Any help would be great.

Phil

--

Dave Peterson