I have a spreadsheet that holds the following :-

Col A Col B

CIO1 BB0191609
CIO2 BB0191491
CIO3 BB0198586


The values in Col B change regularly so I don't want to hardcode them. Col
B line 1 is named CIO1 & Col B line 2 is named CIO2 etc.

In another spreadsheet I need to find the values in Col B. I am using the
following code :-

iCol1 = Cells.Find(What:="=CIO1", After:=ActiveCell).Activate

This isn't finding the column with BB0191609.

Can anyone help ?