Results 1 to 5 of 5

How to change the cell reference in a LEN formula by using Active cells

Threaded View

  1. #1
    Registered User
    Join Date
    02-22-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    25

    How to change the cell reference in a LEN formula by using Active cells

    Good day to everyone. I'm relatively new to Macro excel and I am having problems regarding counting the length of characters in my program.

    I have a program that requires 110 fields that has different character limits. For example: Field1 must limit the number of characters by 3, Field 2 must be limited to 10 characters etc. until field 110.

    Now I used the LEN argument with this code:

     = LEN(A5)<=3
    =LEN(B5)<=10
    =LEN(C5)<=35
    etc. until Field 110 which is cell DF5
    I inputted these formula in rows A3 to DF3 (110 fields) so that It will return a TRUE/FALSE statement per cell.

    Now my problem is, I have a lot of rows that must be checked and they are all displayed in rows A5 to DF5, A9 to DF9, A16 to DF16 etc. etc.

    I need to check all of their character limits per set of row, but there's just too many. Editing will take too much time so I was thinking, Is it possible to use the LEN argument by referencing the active cell?

    I was thinking that if I select a particular cell, then my formula's cell reference will change based on the cell I selected.

    Like for example, instead of just referencing a particular cell with the =LEN(A5)<=3, can I do something like this: =LEN(ActiveCell.Select)<=3?

    Obviously, this formula of =LEN(ActiveCell.Select)<=3 doesn't work, I just used it to describe what I wanted to do. I tried looking at the forum but I couldn't find anything that was like my problem.

    I'm sorry if it was long I wanted to be descriptive about it xD Thank you
    Last edited by crisshinn; 03-05-2011 at 01:19 AM.

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