| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for 3 types of data
I would like to test a cell such that if any of 3 criteria
are met, then the cell is included in the routine. For Each Cell In DataRange If Cell.Value = a single capital letter Or Cell.Value = an integer between 1 and 99 Or Cell.Value = a combination of the two ( ie D99) Then code etc End If Next How can I achieve this please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I hide unused file types from file types list in save dial | Excel Discussion (Misc queries) | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
| Sun IF two data types are the same in a single column | Excel Discussion (Misc queries) | |||
| Mixed data types in a cell | Excel Discussion (Misc queries) | |||
![Stuart[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
