ExcelBanter - Parameters for Find method

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Parameters for Find method (https://www.excelbanter.com/excel-programming/306109-parameters-find-method.html)

Martin[_17_]

Parameters for Find method

Using Excel 2000

The Find method remembers all the parameters that were last used with
it, such as the string that was searched for.

Is it possible within a macro to access those saved values so that I
can then reuse them in a UserForm.

Thanks,

Martin

Dave Peterson[_3_]

Parameters for Find method

I don't think so.

Martin wrote:

Using Excel 2000

The Find method remembers all the parameters that were last used with
it, such as the string that was searched for.

Is it possible within a macro to access those saved values so that I
can then reuse them in a UserForm.

Thanks,

Martin

--

Dave Peterson

All times are GMT +1. The time now is 02:09 PM.