| 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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referencing Named Cells in Find
Try
iCol1 = Cells.Find(What:=Range("CI01").Value, After:=ActiveCell).Activate -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jill1" wrote in message ... 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 ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referencing Named Cells in Find
Thanks for your help Bob, unfortunately this hasn't worked either !
Jill "Bob Phillips" wrote: Try iCol1 = Cells.Find(What:=Range("CI01").Value, After:=ActiveCell).Activate -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jill1" wrote in message ... 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 ? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referencing Named Cells in Find
iCol1 = ActiveWorkbook.Names("CIO1").RefersToRange
returns BB0191609 (the actual value of cell named "CIO1") Regards, Stefi €žJill1€ť ezt Ă*rta: 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 ? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referencing Named Cells in Find
Thank you so much Stefi. This works a treat
"Stefi" wrote: iCol1 = ActiveWorkbook.Names("CIO1").RefersToRange returns BB0191609 (the actual value of cell named "CIO1") Regards, Stefi €žJill1€ť ezt Ă*rta: 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 ? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referencing Named Cells in Find
You are welcome! Thanks for the feedback!
Stefi €žJill1€ť ezt Ă*rta: Thank you so much Stefi. This works a treat "Stefi" wrote: iCol1 = ActiveWorkbook.Names("CIO1").RefersToRange returns BB0191609 (the actual value of cell named "CIO1") Regards, Stefi €žJill1€ť ezt Ă*rta: 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 ? |
| Reply |
| 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 | |||
Linear Mode
