Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searching Column for text in Excel

Status
Not open for further replies.
mkjp2011

mkjp2011

Programmer
Aug 24, 2010
15
US
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?

 
Sort by date Sort by votes



Code: 
dim xl as excel.application, lRow as long
...
lRow = xl.YourSheetObject.Columns(yourColumn).Find("YourFindValue").Row


Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Upvote 0 Downvote
This works great! However now I run into the problem, where if that certain text is not found then it returns an unknown value and stops my script. How do I handle the situation if the value is not found?
 
Upvote 0 Downvote


Code: 
dim xl as excel.application, lRow as long, rng as range
...
set rng = xl.YourSheetObject.Columns(yourColumn).Find("YourFindValue")

if not rng is nothing then 
  lrow = rng.row
end if

...

set rng = nothing

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Upvote 0 Downvote
I tried this, however Range must not be supported. Because it tells me 'Range' is not a record type. What could be the reason?
 
Upvote 0 Downvote


as Excel.Range, programmer!

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Upvote 0 Downvote
I tried that already. Still the same error. Yes I am a programmer and I usually don't have to use forums.
 
Upvote 0 Downvote


The try declaring rng as Object

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Upvote 0 Downvote
I tried that yesterday and it worked. However once I do this, if it comes across something that is not in that column then the macro stops the macro and says Object value is set to Nothing; stopping macro playback. How could I avoid this?
 
Upvote 0 Downvote



Please post your control code for this process.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CADD6953
  • Locked
  • Question
Help needed with syntax/logic in Attachmate macro
2
Replies
26
Views
1K
SkipVought
S
jeaneshe
  • Locked
  • Question
How do I select different Excel cells using a variable column loop?
Replies
10
Views
699
SkipVought
S
CADD6953
  • Locked
  • Question
Macro for Excel to Attachmate and Back Again 1
2
Replies
34
Views
2K
SkipVought
S
dhsd
  • Locked
  • Question
VBA code works fine in debug mode but not when I run it
Replies
5
Views
605
SkipVought
S
AlbertShenko
  • Locked
  • Question
Excel VBA Not Sending F keys to Attachmate 1
Replies
15
Views
1K
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top