| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting every fourth cell in a coloumn
Hi all. I would like som help on the following:
Like when using the ctrl key, I want to select several non-adjacent cells. I want to select every fourth cell in a coloumn with about 1500 cells. The code below helps me to move the selection down, but it does not keep the previous selection. Any sugestions? ActiveCell.Select For i = 1 To 1500 ActiveCell.Offset(3).Select i = i + 1 Next ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort one coloumn according to another coloumn on another worksheet | Excel Worksheet Functions | |||
| Format individual coloumn cell with corresponding coloum cell resu | Excel Worksheet Functions | |||
| Trying to find the fourth blank cell in a column | Excel Discussion (Misc queries) | |||
| highlight row and coloumn of selected cell | Excel Discussion (Misc queries) | |||
| How to delete values of a cell if it is found in another coloumn | Excel Worksheet Functions | |||
Threaded Mode
