+ Reply to Thread
Results 1 to 3 of 3

Naming a Range Code:formula is then copied

  1. #1
    Registered User
    Join Date
    06-28-2006
    Posts
    28

    Unhappy Naming a Range Code:formula is then copied

    Hi guys,

    I've written code that is using an IF statement to look at something in a range and then returning a certain value. This formula is then copied and pasted down for 250 rows. How do I then name this range where the values have been pasted? The code is...

    Please Login or Register  to view this content.

    The range that has been filled in needs to be called REALCCY.

    I don't want to name a fixed range as the report (REAL2) will have a different number of columns depending on when I run it.

    Many thanks in advance for any assistance.

    Dom.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    re: Naming a Range Code:formula is then copied

    Maybe you are looking for something like Dynamic Ranges

  3. #3
    Registered User
    Join Date
    06-28-2006
    Posts
    28

    re: Naming a Range Code:formula is then copied

    Will take a look at it thanks.

+ 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