+ Reply to Thread
Results 1 to 5 of 5

Cell Function to Monitor a Specific Range

  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Cell Function to Monitor a Specific Range

    Is there a way for the Cell("Contents") function monitor a specific column of cells?

    For example, in cell A1 I have the formula
    Please Login or Register  to view this content.
    and the data to monitor changes in would be in column B, D or E, display this value in A1 with the stated formula. I thought maybe the Cell() be nested within an If function.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Cell Function to Monitor a Specific Range

    So you want to use a specific cell, let's say A1 to monitor a specific column (let's say B). What are we monitorinig it for? Changes? If there is a change, what do you want A1 to say/do? What if there are multiple changes? Are we talking about manual changes or changes due to formulas? (for example in B7 is a formula = C1+D1 and someone changes D1 which causes B7 value to change)?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Re: Cell Function to Monitor a Specific Range

    I think you are overcomplicating it. I want Cell("contents") to perform the way it would normally do but limit it to columns A, B and C. The way Cell("contents") normally behaves is, if you type anything in any cell other than the one with Cell() function in the same sheet will display the same value/text as where the last cell was written.

    If I wrote "hi" to cell D7, A1 would also display "hi". If I then proceeded to write "hello" to cell F2, A1 would display "hello". I would like to have the Cell("contents") function limited to specified columns. I played around with if, countif and ranges but not sure if I can approach the Cell() function in this manner.

  4. #4
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Re: Cell Function to Monitor a Specific Range

    Quote Originally Posted by ChemistB View Post
    Are we talking about manual changes or changes due to formulas? (for example in B7 is a formula = C1+D1 and someone changes D1 which causes B7 value to change)?
    Oh I see what you mean. If there are two cells within a column that may have a formula that reference the same cell and both change at once.... I see... I do not think this will be the case. I am having drop down lists for several columns with no formulas as far as I am envisioning.... The end user, or anyone for that matter, cannot simultaneously click and select multiple dropdown list items unless I've mistaken.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Cell Function to Monitor a Specific Range

    You can't do what you are describing with a worksheet function, Cell or otherwise.

    You would need a VBA Change event handler monitoring changes to the specific range you require. Ideally, that range should be kept to a minimum.

    It would look something like this:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. [SOLVED] Monitor specific cells for change
    By iwannabakat in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-08-2014, 07:39 PM
  2. [SOLVED] Copy worksheet with specific name and no blank cell in a specific range
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-05-2013, 11:50 AM
  3. [SOLVED] how to stop Command button If specific number is entered in a specific cell range
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2013, 05:10 AM
  4. [SOLVED] Monitor date and time range
    By smcelv1 in forum Excel General
    Replies: 5
    Last Post: 06-13-2012, 09:15 AM
  5. [SOLVED] Log to monitor the function
    By pact in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2009, 03:26 AM
  6. Selecting specific cell if score falls within specific range
    By Rennier in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-12-2008, 02:22 PM
  7. Replies: 1
    Last Post: 01-13-2005, 11:06 PM

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