Query regarding Names ( Urgent )

[nateshk]

Hi !

I have created a name for a range of cells in my worksheet.

Is it possible for me to access an individual cell in this name ?

Thanx in advance

 

[DaleWatson123321]

Yes, it's possible.

A couple of options would be:

1) VLOOKUP function

2) DCOUNTA function

To access the individual cell, you would need to have some method of identifying the record (ROW) that contains the individual cell, and a means of determining the COLUMN.

Hope this helps. If you need further help, and because of the urgency, I'd suggest you offer to email a copy of your file.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[dwilson01]

The answer to your question is, YES. The following will find and select the cell containing the name "Josh" in the named range "Range1".

Set Rng = Names("Range1").RefersToRange
Set C = Rng.Find("Josh")
C.Select

 

[xlbo]

Not sure exactly what you're referring to but to access cell 5 in a range called "RNG", you would use
=index(rng,5)

This will return the 5th value in "RNG"
HTH Rgds
~Geoff~

 

[nateshk]

Hi,

thanx for rsponding quickly.

i have got this code in one of my excel sheet cell

='C:\[A.xls]81'!$HB$8

the formula refers to a different Workbook called C:\A.xls.

Can this way used to refer to a name "81" ?

if not what does "81" stand for ?

I have checked for hidden sheets in "A.xls" but was of no use.

Thanx in advance.

 

[dwilson01]

In the formula ='C:\[A.xls]81'!$HB$8, the 81 represents the sheet name in workbook A. Is the formula working? If so, there must be a sheet named 81 in the file A.xls. Check the properties - contents of workbook A.xls. Point to File - Properties, click Contents, under Worksheets look for 81.

Hope this helps

Dave

 

[nateshk]

Hi dwilson01 ,

Thanx for u r help.

Yes i checked file\properties\Contents , but i didnt find 81.

Also the formula shows #REF error.

Can i assume safely that the sheet has been deleted.

Thanx

Natesh

 

[dwilson01]

Yes, the #REF means the reference to the cell(s) has been broken.

 

[nateshk]

Hi ,

Thanx dwilson01

Natesh