Search:

Type: Posts; User: baldgeezer

Search: Search took 0.03 seconds.

  1. Re: Excel VBA macro to set validation list based on other cell

    FYI I've just added the line

    var = Range(name).Address

    after where I create name = Range("B2").Value & "_locations" and it fails on that call reporting the same error so this is the culprit. It...
  2. Excel VBA macro to set validation list based on other cell

    Hi,

    I have an XL sheet where I have a simple dropdown with list with 2 entries (Manufacturing and Health). For each of these I have separate named ranges that include the locations that we work...
Results 1 to 2 of 2



Click Here to Expand Forum to Full Width