Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I've been goofing around, writing a tic-tac-toe game. I define the eight possible winning rows as ranges. I can refer to the Cells in the horizontal and vertical ranges by saying something like: for i = 1 to 3 rows(1).Cells(i).select next i However, for the two diagonal rows, this select statement selects the topmost cell in the range and the two cells directly below the first cell, not the other two actual cells in the range. Is there a simple syntax that will work for all the ranges? Like I say, just goofing around, but it irks me to treat these two rows differently. Thank you, Doug |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pick cells on the diagonal | Excel Discussion (Misc queries) | |||
Diagonal Borders | Excel Discussion (Misc queries) | |||
Need diagonal lines behind printed cells. | Excel Discussion (Misc queries) | |||
Creating cells with Diagonal borders | Excel Discussion (Misc queries) | |||
text diagonal | Excel Discussion (Misc queries) |