|
-
Dec 14th, 2012, 06:46 AM
#7
New Member
Re: Excel Find Method in Excel VBA (Any version of Excel)
Hi koolsid,
Good tool.
Could you help me with (1) adding deletion of the rows that where found by .find and (2) find and list of about 50 values (and later delete the rows)?
Foer (1) I used scenario 3 and replaced the "MsgBox "The Search String has been found these locations: " & FoundAt" by "Range(FoundAt).EntireRow.Delete".
This worked find for some hits but "Range" reported an error for a long string for "FoundAt" (e.g. 70).
I would apprecitate any help on this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|