+ Reply to Thread
Results 1 to 2 of 2

Changing Target Range to A Specific Range

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Changing Target Range to A Specific Range

    Hi all,

    I found this code at:
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=380

    I would like to change my Target range to just (C7:C) so that it will only search data in the specific column and start on the specific row.

    I'm not sure if I have to replace "xlByColumns" with something else or just somehow set it to be only column "C"?

    also, would replacing (.Cells(1 with .Cells(7 set it to start on row 7?

    Please Login or Register  to view this content.
    Any help is appreicated

    Thanks,

    BDB

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Changing Target Range to A Specific Range

    Maybe just
    Please Login or Register  to view this content.
    ... applied, for example, as

    =RngIsBlank(c7:c10)

    Not sure this is worth a function. You could use native functions, array entered:

    =AND(ISBLANK(C3:C9))
    Last edited by shg; 04-19-2010 at 05:58 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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