Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ".Find"
I'm having trouble understanding the VBA ".Find" method. VBA Help hasn't
been much help. I'd like to see a better writeup with examples. Any suggestions about where to look? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ".Find"
Hi SidBord,
It might help if you explained what specifically it is that you are having difficulty with. Perhaps you could turn on the macro recorder while performing find tests of your own devising. The resultant code might prove instructive. For a plethora of examples see previous posts in this NG, e,g,: http://tinyurl.com/869pe --- Regards, Norman "SidBord" wrote in message ... I'm having trouble understanding the VBA ".Find" method. VBA Help hasn't been much help. I'd like to see a better writeup with examples. Any suggestions about where to look? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ".Find"
Maybe this will help:
Sub findit() 'finds the text "findthis" in column A Dim fndRange As Range With Columns(1) Set fndRange = .Find(what:="findthis", LookIn:=xlValues) End With If fndRange Is Nothing Then MsgBox "Not found" Else fndRange.Interior.ColorIndex = 35 End If End Sub Regards Rowan SidBord wrote: I'm having trouble understanding the VBA ".Find" method. VBA Help hasn't been much help. I'd like to see a better writeup with examples. Any suggestions about where to look? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ".Find"
Thanx, Guys ... great replies, except they don't address my question. I'm
looking for written material of the sort in Help, except useful. I've played around with the code, but too many questions keep coming up. I really don't want to keep running to the forum for each question I have. I'd just like to study it by reading something authoritative on the subject... a good reference. "Rowan Drummond" wrote: Maybe this will help: Sub findit() 'finds the text "findthis" in column A Dim fndRange As Range With Columns(1) Set fndRange = .Find(what:="findthis", LookIn:=xlValues) End With If fndRange Is Nothing Then MsgBox "Not found" Else fndRange.Interior.ColorIndex = 35 End If End Sub Regards Rowan SidBord wrote: I'm having trouble understanding the VBA ".Find" method. VBA Help hasn't been much help. I'd like to see a better writeup with examples. Any suggestions about where to look? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA ".Find"
Maybe excel's help (not VBA's) for Find.
Hit ctrl-f and then F1. SidBord wrote: I'm having trouble understanding the VBA ".Find" method. VBA Help hasn't been much help. I'd like to see a better writeup with examples. Any suggestions about where to look? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
"FIND" generates "Type mismatch" error | Excel Programming |