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

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