Results 1 to 2 of 2
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Copying data validation via VBA (Excel 2000)

    Is there a problem with copying data validation with VBA?

    I have a number of cells with data validation applied.
    The validation restricts the input to entries from a named range.
    Tee VBA pastespecial ->datavalidations can be recorded but won't run afterwards.

    Any ideas?

    zeddy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying data validation via VBA (Excel 2000)

    It works for me in Excel 2002. What was the code that you recorded?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •