+ Reply to Thread
Results 1 to 3 of 3

Cell info within a given range

  1. #1
    Forum Contributor
    Join Date
    02-25-2008
    Posts
    101

    Cell info within a given range

    Hiya,

    Hope everyone's well.

    Is there any way I can get a cell's column number within a given range? Similar to =CELL("col"), but within a range (e.g. B2:G20).

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    for the range (b2 : g20)
    the column number should be
    Please Login or Register  to view this content.
    I need your support to add reputations if my solution works.


  3. #3
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Cell info within a given range

    row(), column() and Cell("col/column";reference) only return information of the upper left cell in the range.

    What should your outcome be?
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

+ 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. Replies: 1
    Last Post: 07-17-2008, 01:21 PM
  2. returning something in a cell if another cell has info input
    By stevesunfold in forum Excel General
    Replies: 14
    Last Post: 04-01-2008, 08:51 AM
  3. Getting a range from an array formula contained in a cell
    By kayard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2007, 04:08 PM
  4. Input range only and calculate Average of that range in another cell
    By Kokomo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-27-2007, 09:35 AM
  5. Pasting cell range to make selections from existing combobox listings
    By darmstrong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2007, 09:48 AM

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