+ Reply to Thread
Results 1 to 5 of 5

Select the blank range and set the data validation

  1. #1
    Forum Contributor
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    135

    Select the blank range and set the data validation

    Hi All,

    I have an excel report contains the data range C11 to End(xlDown). It’s dynamic range. So my question is here I have to select the range “D11 to D22” and set the data validation like “True” or “False” based on the range "C" column.

    I have tried the macro using xlUP but unable to select the range dynamically and how to set the data validation looking for your assistance on this fix this.


    Thanks/Raju
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: Select the blank range and set the data validation

    To select the range in a macro, you would use xlUp on Column C and then offset to the next column.
    Please Login or Register  to view this content.
    With that said, you rarely have to select cells or ranges of cells in VBA in order to do things with them. However, since you did not show us any code, I am not sure exactly how you want to apply Validation to the range.

  3. #3
    Forum Contributor
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    135

    Re: Select the blank range and set the data validation

    OMG that's awesome, This is what am looking for the whole day... Thank you so much, Rick.... .........

  4. #4
    Forum Contributor
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    135

    Re: Select the blank range and set the data validation

    Solved am unable to edit my post...

  5. #5
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: Select the blank range and set the data validation

    Quote Originally Posted by rajuganapathy View Post
    Solved am unable to edit my post...
    See the second section down...

    https://www.excelforum.com/faq.php

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multi-select from data validation isn't working with auto-assigning data validation
    By iPenguin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2017, 12:37 PM
  2. Tell macro to skip blank cells in a range and only select those with data?
    By Belinea2010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2016, 08:33 PM
  3. Replies: 1
    Last Post: 10-16-2014, 08:00 PM
  4. [SOLVED] Data validation using dynamic range ignoring blank formulas
    By gerainta in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-22-2013, 09:24 AM
  5. Using Defined Names with Data Validation Depend and Data Validation Multi Select
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2012, 05:36 PM
  6. Replies: 4
    Last Post: 09-17-2010, 03:44 AM
  7. Select last blank cell in a range of data
    By DJ Dusty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2006, 01:23 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1