Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

EXCEL PROCEDURE

  Asked By: Clariee    Date: Jan 05    Category: MS Office    Views: 746
  

I AM NEW TO EXCEL AND I AM TRYING TO CREATE A PROCEDURE TO SELECT THE
EMPTY CELL IN A RANGE A1:I9 FOR MY SUDOKU GAME, PROCEDURE MUST BE GOOD
FOR ALL FUTURE SUDOKUS WHEN NUMBERS CHANGE POSITION, IS THERE ANY ONE
WHO CAN HELP ME?

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Aadi Martin     Answered On: Jan 05

First of all, you should try and do this in Excel, before moving on to
VBA.

In Excel, how can you determine whether a cell  is empty? There is a
formula called ISBLANK that you can use. It returns True or False. Now
you can set up your own similar grid, and then find the formula that
gives a True answer.

If you want to be a bit smarter, you can loop through your game  grid
with a single formula, and this will result in your required VBA code.
Have a go, and let us see your version for further comment if required.

 
Answer #2    Answered By: Jawwad Akram     Answered On: Jan 05

By the way, visit www.harisworld.com for an all-in-one sudoku Excel
program.

 
Answer #3    Answered By: Shirley Allen     Answered On: Jan 05

THANK FOR YOUR INFORMATION, BUT I TRIED THAT ALREADY, WHAT I WANT IS TO SELECT
ALL EMPTY CELL IN THE SUDOKU AT ONCE USING EITHER A MACRO OR VBA, BUT I CANNOT
GET THE CORRECT SYNTAX, PLEASE HELP

 
Answer #4    Answered By: Myrna Brown     Answered On: Jan 05

How about

Range("A1:I9").SpecialCells(xlCellTypeBlanks).Select


This will select  the blank cells in a given range, no matter where/what they
are.

 
Didn't find what you were looking for? Find more on EXCEL PROCEDURE Or get search suggestion and latest updates.




Tagged: