http://www.cijoint.fr/cjlink.php?file=cj200910/cij9dWRCr1.xls, - I don't create any of the original model grids, nor the soluce proc VBA-Excel: Appending Text to Existing Word Document – at Beginning, VBA-Excel: Appending Text to an Existing Word Document – at the End, Excel-VBA : Range - Lock/Unlock Specific Cells, VBA-Excel: Create and Save the Word document, VBA-Excel: Get the names of all WorkSheets in a Excel (WorkBook), VBA-Excel: Read XML by Looping through Nodes. Step 2: In Excel Options window choose “Add-Ins”. Sudoku. The logic based solvers and the UI probably took the most work - the actual brute force solv… Follow the below steps. I started trying to develop a Sudoku solver in Excel using VBA. @David: try now, I have uploaded the Excel 2007 version originally. Download Link : SUDOKU Solver. Mega Sudoku Generator Excel Free Downloads - 2000 Shareware periodically updates software information and pricing of Mega Sudoku Generator Excel from the publisher, so some information may be slightly out-of-date. - Rotations per group of columns or rows The code could be modified to VBA without great difficulty. Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation – Part 2/2 By Diego Oppenheimer. Join 100,000+ others and get it free. Solving Sudoku with EXCEL. Click here to download the sudoku solver workbook. If Excel does not ask you whether to enable macros and automatically disables it on opening the file, it means your macro security setting is set on "High". Step 1: Go to the FILE tab. The VBA code of the macro is open for everyone to study (and copy if it. Sudoku is a very effective way to keep your brain cells ticking. So much better than timer controlled DSLR on dining table I must say. I have noticed it too. Here is a small holiday card from Chandoo.org HQ. Sudoku solver in excel vba. I wrote an Excel/VBA Sudoku Puzzle Teacher /Puzzle Solver program in Excel/VBA with about 3000 lines of VBA code :  Sudoku Teacher Sudoku Helper. In his spare time he wrote a small VBA macro to solve Sudoku. Regards, Only works for simple puzzles. Select 'Save' from the IE popup dialog. Sudoku is a Japanese number placement game that has fast become a mainstay in daily newspapers across the world. Fun In Excel 5 Ways Of Fun With Spreadsheets Professor by professor-excel.com. (It probably doesn't matter, because I only have Excel 2003.). Dan’s spreadsheet was great in that, unlike many of the Sudoku solving spreadsheets out there, it didn’t use any VBA or other scripting to do the work of solving the puzzles, and relied instead on the iterative calculation feature of … Each row, column, and 3x3 subgrid must contain each of the digits from 1 through 9 without any digits repeating. I am a huge sudoku fan and I solve sudoku whenever I have few minutes to kill. It is possible to use Excel to solve Sudoku. Read my story • FREE Excel tips book. I do this by sharing videos, tips, examples and downloads on this website. Using Visual Basic for Application (VBA), I was able to teach Excel how to solve Sudoku puzzles using logic and advanced techniques. the candidates). January 30, 2015 June 18, 2013 by Sumit Jain. Nice macro, though, Hi maybe my question was not understood. Steps: Open a new WorkBook; Create a SUDOKU template; Create a Button; Copy Paste the Complete Code; Press the button till the SUDOKU is solved. Thanks to: Indiana University Knowledge Base. Step 3: At the bottom chooses “Excel Add-Ins” and click on “Go”. Press F5. In the newspaper each day, they may fill in 20-30% of the 81 numbers in the grid. The book is 10 years old, so it isn't exactly cutting edge, but it is a good place to start. Still on fence about Power BI? A while back, a fellow PM on the Excel team, Dan Cory, wrote a spreadsheet for solving Sudoku puzzles using Excel formulas and made it available on Office Online . Sudoku is a very famous number based puzzle with a 9×9 grid of cells. To date, we have not been able to find a single puzzle not been able to be solve. Here is an Excel puzzle for the popular number puzzle, Sudoku. For changing your security setting, do the following: [...]. The file is unlocked, so if you are curious, go around and poke the code. Excel-VBA : Send Mail with Embedded Image in message body From MS Outlook using Excel. There is a nice little book "Programming Sudoku" by Wei-Meng Lee that discusses how to write a Sudoku solver in VB.Net. ลอง search Google ว่า Excel Sudoku Solver VBA ดูครับ On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2021. Calendars, invoices, trackers and much more. Sudoku is a 9x9 grid. [...] Solve Sudoku Puzzles using Excel Macros – Excel Games …How to Create a Suduko Puzzle. Step 4: Now check the box “Solver Add-in” and click on, Ok. Now you must see “Solver” under the data tab. After a few interactions with Excel, I moved to Visual Basic using VS2005. It was unique because rather than use brute force VBA to determine every possible combination of numbers to solve a given puzzle, it used recognized human logical techniques that had been developed for the Sudoku game by enthusiasts worldwide. Excel Game : Sudoku in Excel - Work and Play. This is the most complete and standalone Sudoku puzzle suite for Windows. it has to be able to solve easy/medium difficulty Sudoku . This solver is the most downloaded among Sudoku solvers made in Excel-VBA. Excel-VBA : Send a Mail using Predefined Template From MS Outlook Using Excel, Excel-VBA : Send a Simple Mail From MS Outlook Using Excel. excel sudoku solver code Sudoku solver - Excel VBA Macro. Each of the 9 rows, columns and 3×3 blocks should be filled in such a way that they have all the numbers from 1 to 9. @Arnold: You can try the Sudoku Generator at http://www.opensky.ca/~jdhildeb/software/sudokugen/. Sudoku is a very effective way to keep your brain cells ticking. Excel Sudoku Generator. Vba Sudoku by nielshorn.net. It's all here. Is there an excel sudoku creator, my mother in law can't stop doing them and buying books is expensive? - Permutations digit numbers 1) Just as I did this, I was pretty much interested in creating an excel that could generate SUDOKU puzzles. The included download file includes an Excel workbook that has a VBA module (macro) that has all the functions necessary to create, clear and solve a Sudoku puzzle. In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch. Example. - But also rotations in groups. Notify me of when new comments are posted via e-mail. Send Mail With Link to a Workbook, From MS Outlook using Excel. VBA-Excel: Change Font, Color, Weight of Table Data in the Word document, VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order. VBA-Excel: Create or Add Worksheets at the Run time. I just. Share Twitter LinkedIn Facebook Email Print Today’s author, Charlie Ellis, continues discussing the spreadsheet he built to solve Sudoku puzzles. Tutorial mode … thanks, Dear Arnol - here is the link for what you want. He is kind enough to let me share this with all of you. My aim is to make you awesome in Excel & Power BI. It works for all. VBA-Excel: Convert Numbers (Rupees) into Words OR Text - Updated Till 1000000 Crore With Decimal Numbers, VBA-Excel: Open an Existing Word Document, VBA-Excel: Add/Insert a Image/Picture in Word Document. Press the button till the SUDOKU is solved. - the worksheet is protected with blank, It seems that others have successfully opened this file, so what am I doing wrong? @Struzak: Thank you. Please go to http://www.sudexel.com/sudokuxls Excel-VBA : Open a MS Word Document using Excel File using Explorer Window. With that in mind, suppose in an Excel spreadsheet, you create a grid as shown in Fig. If so, Sudoku is not solved. Dear Arnold, After Creating the SUDOKU template you page should look like this: NOTE: Make sure you create the template in correct cells else you will have to change the code, To know how to add a button Click here (Assign-a-macro-to-a-button), Press Alt+F11 and Copy paste the code below, Dim mainWorkBook As Workbook Dim arrMatrix(1 To 9, 1 To 3, 1 To 3) Dim arrOptions(9) Dim arrAlreadyUpdated() Dim blnHaveSomethingToFill, Sub Sumit() Set mainWorkBook = ActiveWorkbook Call FnGetValues, blnHaveSomethingToFill = False For i = 1 To 9 StrA = "" ‘intAUCounter = 0 ‘ReDim Preserve arrAlreadyUpdated(0) For j = 1 To 3 For k = 1 To 3 ‘MsgBox i & " " & j & " " & arrMatrix(i, j) If arrMatrix(i, j, k) = "" Then, Call FnFillOptionsArray Call FnCalculate(i, j, k) intCounterO = 0 ‘StrA = "" For p = 0 To 8 StrA = StrA & " " & arrOptions(p) If arrOptions(p) = 0 Then intCounterO = intCounterO + 1 End If Next If i = 4 Then ‘MsgBox i & j & k & " " & StrA End If, ‘intAUCounter = intAUCounter + 1 ‘ReDim Preserve arrAlreadyUpdated(intAUCounter) ‘arrAlreadyUpdated(intAUCounter – 1) = i & " " & j & " " & k ‘MsgBox arrAlreadyUpdated(intAUCounter – 1) & " Entered", If intCounterO = 8 Then ‘intAUCounter = 0 For p = 0 To 8 If arrOptions(p) <> 0 Then arrMatrix(i, j, k) = arrOptions(p) ‘MsgBox "have" blnHaveSomethingToFill = True End If Next End If End If Next Next If blnHaveSomethingToFill = False Then For a = 1 To 9 StrA = Replace(StrA, " ", "") strTemp = StrA If Len(strTemp) – Len(Replace(strTemp, CStr(a), "")) = 1 Then ‘ MsgBox StrA intLocation = InStr(1, StrA, CStr(a), 1) ‘ MsgBox intLocation intCell = 0 If Int(intLocation / 9) <> (intLocation / 9) Then intCell = Int(intLocation / 9) + 1 Else intCell = Int(intLocation / 9) End If ‘ MsgBox intCell & " Location" ‘arrTemp = Split(arrAlreadyUpdated(intCell – 1), " ") ‘intI = CInt(arrTemp(0)) ‘intJ = CInt(arrTemp(1)) ‘intK = CInt(arrTemp(2)) ‘ MsgBox intI & intJ & intK intC = 0 blnFound = False For j = 1 To 3 For k = 1 To 3 ‘MsgBox i & " " & j & " " & arrMatrix(i, j) If arrMatrix(i, j, k) = "" Then ”MsgBox "411" & arrMatrix(4, 1, 1) intC = intC + 1 ‘MsgBox "intC" & intC ‘MsgBox i & j & k If intC = intCell Then arrMatrix(i, j, k) = a ‘Call FnFillValues ‘ MsgBox i & j & k & "Matched" & " " & a blnFound = True Exit For End If End If Next If blnFound Then Exit For End If Next Exit For StrA = "" strTemp = "" End If Next, arrOptions(0) = 1 arrOptions(1) = 2 arrOptions(2) = 3 arrOptions(3) = 4 arrOptions(4) = 5 arrOptions(5) = 6 arrOptions(6) = 7 arrOptions(7) = 8 arrOptions(8) = 9, For j = 1 To 3 For k = 1 To 3 If arrMatrix(a, j, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(a, j, k) Then arrOptions(m) = 0 End If Next End If Next Next, If a = 1 Then For j = 1 To 3 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 1 To 7 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, If a = 2 Then For j = 1 To 3 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 2 To 8 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, If a = 3 Then For j = 1 To 3 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 3 To 9 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, If a = 4 Then For j = 4 To 6 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 1 To 7 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, If a = 5 Then For j = 4 To 6 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 2 To 8 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, If a = 6 Then For j = 4 To 6 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 3 To 9 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, If a = 7 Then For j = 7 To 9 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 1 To 7 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, If a = 8 Then For j = 7 To 9 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 2 To 8 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, If a = 9 Then For j = 7 To 9 For k = 1 To 3 If arrMatrix(j, k, c) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, k, c) Then arrOptions(m) = 0 End If Next End If Next Next For j = 3 To 9 Step 3 For k = 1 To 3 If arrMatrix(j, b, k) <> "" Then For m = 0 To 8 If arrOptions(m) = arrMatrix(j, b, k) Then arrOptions(m) = 0 End If Next End If Next Next End If, Function FnGetValues() ‘intChar = 69 ‘j = 1 ‘Set mainWorkBook = ActiveWorkbook ‘For k = 1 To 9 ‘ For m = 69 To 77 ‘ For k = 1 To 3 ‘ For i = 1 To 3 ‘ arrMatrix(k, i, j) = mainWorkBook.Sheets("Sheet1").Range(Chr(m) & i + 4).Value ‘ Next ‘ j = j + 1 ‘ Next ‘Next ‘Next, arrMatrix(1, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("E5").Value arrMatrix(1, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("E6").Value arrMatrix(1, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("E7").Value arrMatrix(2, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("E8").Value arrMatrix(2, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("E9").Value arrMatrix(2, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("E10").Value arrMatrix(3, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("E11").Value arrMatrix(3, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("E12").Value arrMatrix(3, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("E13").Value, arrMatrix(1, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("F5").Value arrMatrix(1, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("F6").Value arrMatrix(1, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("F7").Value arrMatrix(2, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("F8").Value arrMatrix(2, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("F9").Value arrMatrix(2, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("F10").Value arrMatrix(3, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("F11").Value arrMatrix(3, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("F12").Value arrMatrix(3, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("F13").Value, arrMatrix(1, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("G5").Value arrMatrix(1, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("G6").Value arrMatrix(1, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("G7").Value arrMatrix(2, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("G8").Value arrMatrix(2, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("G9").Value arrMatrix(2, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("G10").Value arrMatrix(3, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("G11").Value arrMatrix(3, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("G12").Value arrMatrix(3, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("G13").Value, arrMatrix(4, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("H5").Value arrMatrix(4, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("H6").Value arrMatrix(4, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("H7").Value arrMatrix(5, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("H8").Value arrMatrix(5, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("H9").Value arrMatrix(5, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("H10").Value arrMatrix(6, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("H11").Value arrMatrix(6, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("H12").Value arrMatrix(6, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("H13").Value, arrMatrix(4, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("I5").Value arrMatrix(4, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("I6").Value arrMatrix(4, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("I7").Value arrMatrix(5, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("I8").Value arrMatrix(5, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("I9").Value arrMatrix(5, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("I10").Value arrMatrix(6, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("I11").Value arrMatrix(6, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("I12").Value arrMatrix(6, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("I13").Value, arrMatrix(4, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("J5").Value arrMatrix(4, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("J6").Value arrMatrix(4, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("J7").Value arrMatrix(5, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("J8").Value arrMatrix(5, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("J9").Value arrMatrix(5, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("J10").Value arrMatrix(6, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("J11").Value arrMatrix(6, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("J12").Value arrMatrix(6, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("J13").Value, arrMatrix(7, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("K5").Value arrMatrix(7, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("K6").Value arrMatrix(7, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("K7").Value arrMatrix(8, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("K8").Value arrMatrix(8, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("K9").Value arrMatrix(8, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("K10").Value arrMatrix(9, 1, 1) = mainWorkBook.Sheets("Sheet1").Range("K11").Value arrMatrix(9, 2, 1) = mainWorkBook.Sheets("Sheet1").Range("K12").Value arrMatrix(9, 3, 1) = mainWorkBook.Sheets("Sheet1").Range("K13").Value, arrMatrix(7, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("L5").Value arrMatrix(7, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("L6").Value arrMatrix(7, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("L7").Value arrMatrix(8, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("L8").Value arrMatrix(8, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("L9").Value arrMatrix(8, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("L10").Value arrMatrix(9, 1, 2) = mainWorkBook.Sheets("Sheet1").Range("L11").Value arrMatrix(9, 2, 2) = mainWorkBook.Sheets("Sheet1").Range("L12").Value arrMatrix(9, 3, 2) = mainWorkBook.Sheets("Sheet1").Range("L13").Value, arrMatrix(7, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("M5").Value arrMatrix(7, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("M6").Value arrMatrix(7, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("M7").Value arrMatrix(8, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("M8").Value arrMatrix(8, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("M9").Value arrMatrix(8, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("M10").Value arrMatrix(9, 1, 3) = mainWorkBook.Sheets("Sheet1").Range("M11").Value arrMatrix(9, 2, 3) = mainWorkBook.Sheets("Sheet1").Range("M12").Value arrMatrix(9, 3, 3) = mainWorkBook.Sheets("Sheet1").Range("M13").Value, Function FnFillValues() ‘intChar = 69 ‘j = 1 ‘Set mainWorkBook = ActiveWorkbook ‘For k = 1 To 9 ‘ For m = 69 To 77 ‘ For k = 1 To 3 ‘ For i = 1 To 3 ‘ arrMatrix(k, i, j) = mainWorkBook.Sheets("Sheet1").Range(Chr(m) & i + 4).Value ‘ Next ‘ j = j + 1 ‘ Next ‘Next ‘Next, mainWorkBook.Sheets("Sheet1").Range("E5").Value = arrMatrix(1, 1, 1) mainWorkBook.Sheets("Sheet1").Range("E6").Value = arrMatrix(1, 2, 1) mainWorkBook.Sheets("Sheet1").Range("E7").Value = arrMatrix(1, 3, 1) mainWorkBook.Sheets("Sheet1").Range("E8").Value = arrMatrix(2, 1, 1) mainWorkBook.Sheets("Sheet1").Range("E9").Value = arrMatrix(2, 2, 1) mainWorkBook.Sheets("Sheet1").Range("E10").Value = arrMatrix(2, 3, 1) mainWorkBook.Sheets("Sheet1").Range("E11").Value = arrMatrix(3, 1, 1) mainWorkBook.Sheets("Sheet1").Range("E12").Value = arrMatrix(3, 2, 1) mainWorkBook.Sheets("Sheet1").Range("E13").Value = arrMatrix(3, 3, 1), mainWorkBook.Sheets("Sheet1").Range("F5").Value = arrMatrix(1, 1, 2) mainWorkBook.Sheets("Sheet1").Range("F6").Value = arrMatrix(1, 2, 2) mainWorkBook.Sheets("Sheet1").Range("F7").Value = arrMatrix(1, 3, 2) mainWorkBook.Sheets("Sheet1").Range("F8").Value = arrMatrix(2, 1, 2) mainWorkBook.Sheets("Sheet1").Range("F9").Value = arrMatrix(2, 2, 2) mainWorkBook.Sheets("Sheet1").Range("F10").Value = arrMatrix(2, 3, 2) mainWorkBook.Sheets("Sheet1").Range("F11").Value = arrMatrix(3, 1, 2) mainWorkBook.Sheets("Sheet1").Range("F12").Value = arrMatrix(3, 2, 2) mainWorkBook.Sheets("Sheet1").Range("F13").Value = arrMatrix(3, 3, 2), mainWorkBook.Sheets("Sheet1").Range("G5").Value = arrMatrix(1, 1, 3) mainWorkBook.Sheets("Sheet1").Range("G6").Value = arrMatrix(1, 2, 3) mainWorkBook.Sheets("Sheet1").Range("G7").Value = arrMatrix(1, 3, 3) mainWorkBook.Sheets("Sheet1").Range("G8").Value = arrMatrix(2, 1, 3) mainWorkBook.Sheets("Sheet1").Range("G9").Value = arrMatrix(2, 2, 3) mainWorkBook.Sheets("Sheet1").Range("G10").Value = arrMatrix(2, 3, 3) mainWorkBook.Sheets("Sheet1").Range("G11").Value = arrMatrix(3, 1, 3) mainWorkBook.Sheets("Sheet1").Range("G12").Value = arrMatrix(3, 2, 3) mainWorkBook.Sheets("Sheet1").Range("G13").Value = arrMatrix(3, 3, 3), mainWorkBook.Sheets("Sheet1").Range("H5").Value = arrMatrix(4, 1, 1) mainWorkBook.Sheets("Sheet1").Range("H6").Value = arrMatrix(4, 2, 1) mainWorkBook.Sheets("Sheet1").Range("H7").Value = arrMatrix(4, 3, 1) mainWorkBook.Sheets("Sheet1").Range("H8").Value = arrMatrix(5, 1, 1) mainWorkBook.Sheets("Sheet1").Range("H9").Value = arrMatrix(5, 2, 1) mainWorkBook.Sheets("Sheet1").Range("H10").Value = arrMatrix(5, 3, 1) mainWorkBook.Sheets("Sheet1").Range("H11").Value = arrMatrix(6, 1, 1) mainWorkBook.Sheets("Sheet1").Range("H12").Value = arrMatrix(6, 2, 1) mainWorkBook.Sheets("Sheet1").Range("H13").Value = arrMatrix(6, 3, 1), mainWorkBook.Sheets("Sheet1").Range("I5").Value = arrMatrix(4, 1, 2) mainWorkBook.Sheets("Sheet1").Range("I6").Value = arrMatrix(4, 2, 2) mainWorkBook.Sheets("Sheet1").Range("I7").Value = arrMatrix(4, 3, 2) mainWorkBook.Sheets("Sheet1").Range("I8").Value = arrMatrix(5, 1, 2) mainWorkBook.Sheets("Sheet1").Range("I9").Value = arrMatrix(5, 2, 2) mainWorkBook.Sheets("Sheet1").Range("I10").Value = arrMatrix(5, 3, 2) mainWorkBook.Sheets("Sheet1").Range("I11").Value = arrMatrix(6, 1, 2) mainWorkBook.Sheets("Sheet1").Range("I12").Value = arrMatrix(6, 2, 2) mainWorkBook.Sheets("Sheet1").Range("I13").Value = arrMatrix(6, 3, 2), mainWorkBook.Sheets("Sheet1").Range("J5").Value = arrMatrix(4, 1, 3) mainWorkBook.Sheets("Sheet1").Range("J6").Value = arrMatrix(4, 2, 3) mainWorkBook.Sheets("Sheet1").Range("J7").Value = arrMatrix(4, 3, 3) mainWorkBook.Sheets("Sheet1").Range("J8").Value = arrMatrix(5, 1, 3) mainWorkBook.Sheets("Sheet1").Range("J9").Value = arrMatrix(5, 2, 3) mainWorkBook.Sheets("Sheet1").Range("J10").Value = arrMatrix(5, 3, 3) mainWorkBook.Sheets("Sheet1").Range("J11").Value = arrMatrix(6, 1, 3) mainWorkBook.Sheets("Sheet1").Range("J12").Value = arrMatrix(6, 2, 3) mainWorkBook.Sheets("Sheet1").Range("J13").Value = arrMatrix(6, 3, 3), mainWorkBook.Sheets("Sheet1").Range("K5").Value = arrMatrix(7, 1, 1) mainWorkBook.Sheets("Sheet1").Range("K6").Value = arrMatrix(7, 2, 1) mainWorkBook.Sheets("Sheet1").Range("K7").Value = arrMatrix(7, 3, 1) mainWorkBook.Sheets("Sheet1").Range("K8").Value = arrMatrix(8, 1, 1) mainWorkBook.Sheets("Sheet1").Range("K9").Value = arrMatrix(8, 2, 1) mainWorkBook.Sheets("Sheet1").Range("K10").Value = arrMatrix(8, 3, 1) mainWorkBook.Sheets("Sheet1").Range("K11").Value = arrMatrix(9, 1, 1) mainWorkBook.Sheets("Sheet1").Range("K12").Value = arrMatrix(9, 2, 1) mainWorkBook.Sheets("Sheet1").Range("K13").Value = arrMatrix(9, 3, 1), mainWorkBook.Sheets("Sheet1").Range("L5").Value = arrMatrix(7, 1, 2) mainWorkBook.Sheets("Sheet1").Range("L6").Value = arrMatrix(7, 2, 2) mainWorkBook.Sheets("Sheet1").Range("L7").Value = arrMatrix(7, 3, 2) mainWorkBook.Sheets("Sheet1").Range("L8").Value = arrMatrix(8, 1, 2) mainWorkBook.Sheets("Sheet1").Range("L9").Value = arrMatrix(8, 2, 2) mainWorkBook.Sheets("Sheet1").Range("L10").Value = arrMatrix(8, 3, 2) mainWorkBook.Sheets("Sheet1").Range("L11").Value = arrMatrix(9, 1, 2) mainWorkBook.Sheets("Sheet1").Range("L12").Value = arrMatrix(9, 2, 2) mainWorkBook.Sheets("Sheet1").Range("L13").Value = arrMatrix(9, 3, 2), mainWorkBook.Sheets("Sheet1").Range("M5").Value = arrMatrix(7, 1, 3) mainWorkBook.Sheets("Sheet1").Range("M6").Value = arrMatrix(7, 2, 3) mainWorkBook.Sheets("Sheet1").Range("M7").Value = arrMatrix(7, 3, 3) mainWorkBook.Sheets("Sheet1").Range("M8").Value = arrMatrix(8, 1, 3) mainWorkBook.Sheets("Sheet1").Range("M9").Value = arrMatrix(8, 2, 3) mainWorkBook.Sheets("Sheet1").Range("M10").Value = arrMatrix(8, 3, 3) mainWorkBook.Sheets("Sheet1").Range("M11").Value = arrMatrix(9, 1, 3) mainWorkBook.Sheets("Sheet1").Range("M12").Value = arrMatrix(9, 2, 3) mainWorkBook.Sheets("Sheet1").Range("M13").Value = arrMatrix(9, 3, 3).
A Prendre Ou à Laisser Hier Soir Gain, La Beauce Agriculture, Carrelage Gris Brillant Effet Marbre, La Notre Est Dite Atomique 3 Lettres, Recrutement La Poste Centre De Tri, Cale Nuque Médical, Tracteur Renault D30 à Vendre, Bts Sio Occitanie,