|
-
Nov 7th, 2005, 08:24 AM
#1
Thread Starter
Junior Member
.find
Please help me,
how to find exactly only one string.
For example I would like to find only these ranges which have only "A" not "A...".
here is part of VBA code :
Temp = "A"
Set d(j) = .Find(Temp, LookIn:=xlValues)
If Not d(j) Is Nothing Then
firstAddress = d(j).Address
Do
Total1(j) = Total(j) + 1
Set d(j) = .FindNext(d(j))
d(j).Select
Loop While Not d(j) Is Nothing And d(j).Address <> firstAddress
End If
How to reach it ?
Thank You.
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
|