Esier algorithm inside the loops: Cells(i, j) = Not Cells(i, j)
@SuhailaAbdullah-yn8je4 ай бұрын
Thanks alot! Also if you dont want to keep pressing F9, you can add 1) After all the steps. 2) Right click on the sheet (I dont know whats it called) or from the video, Hightlight Selected Cell. 3) Click View Code then select worksheet from the dropdown. 4) It will auto shows: Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub 5) Add, Target.Calculate in between. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Calculate End Sub 6) Close the tab. All done. I mix this with another yt video and it works for me! Btw Im not IT savvy so idk lol
@RH777725 күн бұрын
How to reverse it?
@northwestrepair7 ай бұрын
you forgot to write the code in the description or in the comment
@meniporat35277 ай бұрын
The code appears on line 20 throughout the duration of the video clip .
@dovenorman586510 ай бұрын
😉 P R O M O S M
@user-sm9jz7ch8z11 ай бұрын
Very impressive! Congrats 🎉
@BhavyaGupta Жыл бұрын
Very Nice Trick 👏
@amrtawfik4878 Жыл бұрын
amazing video would you please the pass the file
@shahasarthouse1472 Жыл бұрын
1
@danyos7772 жыл бұрын
Awesome! First time here and looking forward to more tips and tricks in excel. Thank you!
@nadermounir82282 жыл бұрын
Nice one Peri. It would be awesome if you could explain how u did it.
@meniporat35272 жыл бұрын
Thank you. You can download the code from the link above. If you need further explanation, I'll gladly help. رمضان كريم P.S. إسمي مني
@xlrobot2 жыл бұрын
Very nice Meni! You are alway coming up with creative uses of Excel. Thanks sharing!
@phamnguyenductin2 жыл бұрын
Use the formula: =SEQUENCE(100000) on A1. The value will spill from A1 to A100000.
@meniporat35272 жыл бұрын
Many people still use earlier versions of Excel and they don't have the SEQUENCE function. So your solution won't work on their computer :-(
@spilledgraphics2 жыл бұрын
Hi Meni, another way could be: 1. Ctrl + G 2. On reference: type A10000, press enter. 3. On active cell: A10000, Ctrl + Shift + Up arrow or Home 4. Ctrl + "." (dot) - to move the active cell to cell A1 5. On cell A1, enter =ROW() and then Ctrl + Enter. Hope it helps.
@meniporat35272 жыл бұрын
The shortest solution (so far) is this: 1. Press: ALT+F3 (brings you to the Name Box) 2. enter: A1:A1000000 3. enter =ROW() and Press CTRL+ENTER. That's all Can you find a shorter way???
@avierez1002 жыл бұрын
סימון הספרה 1 בתא A1, מילוי, סדרה, עמודות, ערך סיום 10000 והנה לך יותר קצר.