+ Reply to Thread
Results 1 to 2 of 2

Changing Target Range to A Specific Range

  1. 04-19-2010, 05:38 PM #1
    bdb1974
    bdb1974 is offline
    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
    Reply With QuoteRegister To Reply
  2. 04-19-2010, 05:56 PM #2
    shg
    shg is offline
    Forum Expert 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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1