+ Reply to Thread
Results 1 to 4 of 4

Pass Named Range to Range

  1. #1
    Forum Contributor
    Join Date
    03-21-2004
    Location
    Norwich, CT USA
    MS-Off Ver
    Excel 2010
    Posts
    163

    Pass Named Range to Range

    I need to cycle through some named ranges (zones) and perform actions on the cells withing those ranges. I have worked out the actions that take place in the individual ranges and now want to cycle through the ranges. Im getting an OBJECT REQUIRED error when I try to pass the "name" of the names ranges into the range.


    there are 4 zones named:
    zoneAPrng
    zoneASrng
    zoneFPrng
    zoneFSrng

    Please Login or Register  to view this content.
    Ive tried several variations after reading the help on the error but am at the point that Im just easter egging. Each thing produces a new error.

    Set me strait please
    Robert
    Last edited by Hammer_757; 02-29-2012 at 01:09 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-15-2007
    Location
    Home
    MS-Off Ver
    Office 2010, W10
    Posts
    373

    Re: Pass Named Range to Range

    Hi Robert

    Try:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-21-2004
    Location
    Norwich, CT USA
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: Pass Named Range to Range

    That works perfect!
    and its embarasingly simple :o
    Thnaks for helping lecxe
    Robert

  4. #4
    Valued Forum Contributor
    Join Date
    10-15-2007
    Location
    Home
    MS-Off Ver
    Office 2010, W10
    Posts
    373

    Re: Pass Named Range to Range

    You're welcome. Thanks for the feedback.

+ 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