Searching Column for text in Excel
Searching Column for text in Excel
(OP)
I am trying to search the first column of my excel document using EXTRA! Basic. How would I search that column for a specific text value and then return the row it was found out? Is this possible?
RE: Searching Column for text in Excel
CODE
...
lRow = xl.YourSheetObject.Columns(yourColumn).Find("YourFindValue").Row
Skip,
Just traded in my old subtlety...
for a NUANCE!
RE: Searching Column for text in Excel
RE: Searching Column for text in Excel
CODE
...
set rng = xl.YourSheetObject.Columns(yourColumn).Find("YourFindValue")
if not rng is nothing then
lrow = rng.row
end if
...
set rng = nothing
Skip,
Just traded in my old subtlety...
for a NUANCE!
RE: Searching Column for text in Excel
RE: Searching Column for text in Excel
as Excel.Range, programmer!
Skip,
Just traded in my old subtlety...
for a NUANCE!
RE: Searching Column for text in Excel
RE: Searching Column for text in Excel
The try declaring rng as Object
Skip,
Just traded in my old subtlety...
for a NUANCE!
RE: Searching Column for text in Excel
RE: Searching Column for text in Excel
Please post your control code for this process.
Skip,
Just traded in my old subtlety...
for a NUANCE!