+ Reply to Thread
Results 1 to 3 of 3

general range function in vba

  1. #1
    Registered User
    Join Date
    02-17-2014
    Location
    spain
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post general range function in vba

    Hey forum , first time posting . I am working on a project in excel that replicates suduko . I am having trouble coming up with a function that checks a 3 x 3 area and checks if all the numbers add up to 45.
    so the start should be {Function checkRange (rng as Range) As boolean} . So i just want a function that could highlight an area and it tell me if all the cells in there add upto 45 and return true or false in the cell which holds the formula. I just started vba 2 days ago so i am pretty lost .

    thanks for your time forum

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: general range function in vba

    You may try:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    02-17-2014
    Location
    spain
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: general range function in vba

    Hey so i got the formula to work , i used a different method

    now my next problem is i have to have a subroutine using this formula that checks each row and column of the suduko puzzle and will change the background colour to something other white if the sum value is not 45. I already made the function "checkRange" that shows true or false if an area does not meet criteria. So how would i incorporate this into the subroutine ?

+ 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: 10-03-2013, 03:58 PM
  2. General Ledger Date Range Formula
    By tariqnaz2005 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-15-2013, 03:21 PM
  3. [SOLVED] How to select general (unspecified) range that is active ?
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2013, 11:59 AM
  4. [SOLVED] General question regarding OFFSET function
    By gmatoka in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 12:41 PM
  5. General Question on Range
    By agentsmith83 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2006, 02:45 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