| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing Named Cells in Find
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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a named array | Excel Discussion (Misc queries) | |||
| referencing a 3D Named Range | Excel Worksheet Functions | |||
| Extracting or Referencing named cells in multiple spreadsheets | Excel Discussion (Misc queries) | |||
| Referencing Named Ranges | Excel Worksheet Functions | |||
| Referencing named ranges | Excel Programming | |||
Threaded Mode
