| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select a range
Is there anyway that I can apply this statement to the 1st to the 42n
cell without a for next loop? And .Cells(x, y).Offset(0, 1) < "IND" _ As you can see it checks to see if the value = "IND" in the first cell I also want to check the next 41 cells in that row for the sam criteria. So I want to see if "IND" is anywhere between 1 and 42 Thank -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| I can't select a range in VBA | Excel Discussion (Misc queries) | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| Select Sheet then Select Range | Excel Programming | |||
| Select a range | Excel Programming | |||
![hotherps[_126_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
