Re: is it possible to Restrict Find & Replace to 1 column



Just select the column before doing the F&R.

In article <e8o0hdwYFHA.3712@xxxxxxxxxxxxxxxxxxxx>,
"Simon" <Simon@xxxxxxxxxxxxxxxxxxx> wrote:

> I need to Find and Replace values in a Column
>
> Same data also exists in other columns - so I would like to restrict the
> Find and Replace to
> a specified column
>
> I need to do this in a Macro ie. popup a text box
.



Relevant Pages

  • is it possible to Restrict Find & Replace to 1 column
    ... Same data also exists in other columns - so I would like to restrict the ... I need to do this in a Macro ie. popup a text box ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Using subform value to open new form?
    ... Change the WHERE clause in the macro to this: ... > [TurnId] Like ... > On the Sub form - Locate Turn Id by Contact Person Sub Frm ... I get a popup asking ...
    (microsoft.public.access.forms)
  • Re: A) 2 Contiguous Popups B) The reverse of .onaction
    ... into a worksheet, ws, with a macro to add the controls reading the ws. ... See diagram below for popup 2 and 2.1 ... sub item b ... whereas the actual foing control is of type msoControlButton. ...
    (microsoft.public.excel.programming)
  • Re: A) 2 Contiguous Popups B) The reverse of .onaction
    ... into a worksheet, ws, with a macro to add the controls reading the ws. ... See diagram below for popup 2 and 2.1 ... sub item b ... whereas the actual foing control is of type msoControlButton. ...
    (microsoft.public.excel.programming)
  • Re: A) 2 Contiguous Popups B) The reverse of .onaction
    ... into a worksheet, ws, with a macro to add the controls reading the ws. ... See diagram below for popup 2 and 2.1 ... sub item b ... whereas the actual foing control is of type msoControlButton. ...
    (microsoft.public.excel.programming)