| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search a spreadsheet for words in certain fields
Hi. I'd like to be able to search a spreadsheet for words in certain fields.
I have to copy data from different regions of the spreadsheet, say B1:F45 and B55:F100. There is fixed text the beginning and end of these ranges that I can query, but I'll never know exactly how many rows exist in between in the range. I can query the speadsheet with an OleDbDataReader (VB.NET), but only "SELECT *...", a named range, or a range of cells specifed in the query ([Sheet1$B1:F45]). Is what I want to do possible with ADO.NET? Thanks for the help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search of words | Excel Discussion (Misc queries) | |||
| Search words in array? | Excel Programming | |||
| Search using the words in a cell | Excel Programming | |||
| data analysis on fields with words not numbers | Excel Worksheet Functions | |||
| Search for specific words | Excel Worksheet Functions | |||
Threaded Mode
