If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Find" function question - No code required
I'm trying to use the find function in a macro but form some reason it won't
find anything inserted onto the sheet via a macro. I'm testing it out with a value i've typed in and a value that's been inserted into a cell via a macro. It'll only find the one that's been typed in.......... Is this normal cause its doing my nut in! Thanks in advance |
#2
|
|||
|
|||
"Find" function question - No code required
Are you specifying all the parms that go in that .find statement?
If not, then you're inheriting whatever was used right before that line of code runs--and that could be something your code did, something someone else's code did, or even what the user did. So if the user found something and matched entire cell contents, you may not find your string if wanted xlpart (or match case or ...). And if there's a chance that the cell is hidden (by an autofilter), try searching through formulas instead of values. If none of this helps, share the line of code, the value that you're looking for, and the range where you're searching. N1KO wrote: I'm trying to use the find function in a macro but form some reason it won't find anything inserted onto the sheet via a macro. I'm testing it out with a value i've typed in and a value that's been inserted into a cell via a macro. It'll only find the one that's been typed in.......... Is this normal cause its doing my nut in! Thanks in advance -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|