| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Selecting Based on Criteria
Group, Lets say I have two columns, in column A I have state names lik Illinois, Indiana and Iowa. Lets also say in column B I have numbers. How can I select a range of cells containing numbers for Illinois. Th states will be continuously used. In other words, all the Illinoi cells will follow each other, then right after the final Illinois cel an Indiana range of cells will be continuous and so forth. On an range selection, I'm only selecting one state at a time. Your thought how I can overcome this problem. Thanks again for all your assistance........ Ton -- ajociu ----------------------------------------------------------------------- ajocius's Profile: http://www.excelforum.com/member.php...fo&userid=1769 View this thread: http://www.excelforum.com/showthread.php?threadid=39362 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting rows with the same criteria | Excel Worksheet Functions | |||
| Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
| Selecting rows based on criteria | Excel Discussion (Misc queries) | |||
| Selecting a criteria range over two sheets? | Excel Discussion (Misc queries) | |||
| Selecting Sheets based on Cell Criteria. | Excel Programming | |||
![ajocius[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
