| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REFERENCE CELL
I have this ='Travel Task 2'!H20 and I am getting #Ref - despite the fact
that H20 is the correct cell. Please help. Thanks -- JOHN |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REFERENCE CELL
Are you sure that in that same workbook you have a sheet named Travel Task
2? If you are still struggling, insert the formula again by typing the = sign then going to your Travel Task 2 sheet and clicking in cell H20, then accept the formula. -- David Biddulph "JOHN" wrote in message ... I have this ='Travel Task 2'!H20 and I am getting #Ref - despite the fact that H20 is the correct cell. Please help. Thanks -- JOHN |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REFERENCE CELL
I'd bet you made a typo. Maybe an extra space (leading/trailing or embedded)??
Try selecting H20 on that "sending" sheet Edit|copy go to the "receiving" cell edit|past special|paste link And check out the formula that excel builds. You could also accomplish the same thing by typing the equal sign, then navigating to that cell, selecting it and hitting enter. JOHN wrote: I have this ='Travel Task 2'!H20 and I am getting #Ref - despite the fact that H20 is the correct cell. Please help. Thanks -- JOHN -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REFERENCE CELL
John,
How about the sheet name? If it's even slightly misspelled, you'll get this error. Try rebuilding the formula, either as a formula (type =, go click H20 in the other sheet, and press Enter), or as a copy from H20 and a paste-link into your original cell. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "JOHN" wrote in message ... I have this ='Travel Task 2'!H20 and I am getting #Ref - despite the fact that H20 is the correct cell. Please help. Thanks -- JOHN |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
