you have a period at the end of used range. is there more to it?

"Dave Peterson" wrote:

In the .find statement

..., After:=activecell, ...

or specify whatever cell you want to use.



Btobin0 wrote:

I have a macro where I can search from A1 but I would like to search from
anywhere in the sheet. Does anyone know how to do that?

--

Dave Peterson