>In Excel, if you record a set of keystrokes, you get some other
>keystrokes.  Try this: record "find xyz".  Excel finds a cell
>with xyz.  Play the macro back, and excel just goes to that
>cell blindly, never does a search.  Useless.

Have you ever looked at the actual VBA code generated by the macro record? I
have recorded macros to find out what sneaky stuff it is doing behind the
scenes, and then modified that to achieve the general result I want.

--
http://www.piclist.com#nomail Going offline? Don't AutoReply us!
email listserv@mitvma.mit.edu with SET PICList DIGEST in the body