| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WHAT COULD CAUSE #Ref error ON UNLINKED SHEETS
DEAR ALL
I HAVE A FILE BY NAME SAY CARGO.XLS. In this file there are 20 sheets. In VB i transfer the say three sheets from the cargo.xls file for transmitting from the cargo control to the radio room. What i cant figure out is if I open one sheet and then the other some of the cells get # ref error. For your information-- I do not have any links in the cells showing this error. The formulas in these sheets are referring to the sheet cells itself. What could be the cause. Pls advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
| selecting a single sheet from a volume of sheets in a workbook | Excel Worksheet Functions | |||
| question about many sheets in one warkbook | Excel Worksheet Functions | |||
| Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Threaded Mode
