| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 3-D Reference
I need help with aq 3-D reference error (REF#):
='Sheet1:Sheet5'!B2 Thanks for the help -- FirstVette52 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 3-D Reference
Do the sheets exists?
-- Regards, Peo Sjoblom "FirstVette52" <(My User name is Firstvette 52, too) firstvet52@(my ISP E-mail provider is) netzero.com wrote in message ... I need help with aq 3-D reference error (REF#): ='Sheet1:Sheet5'!B2 Thanks for the help -- FirstVette52 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 3-D Reference
You need to have it wrapped in a formula, what do you expect that particular
string to do? =SUM(Sheet1:Sheet5!B2) -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... Do the sheets exists? -- Regards, Peo Sjoblom "FirstVette52" <(My User name is Firstvette 52, too) firstvet52@(my ISP E-mail provider is) netzero.com wrote in message ... I need help with aq 3-D reference error (REF#): ='Sheet1:Sheet5'!B2 Thanks for the help -- FirstVette52 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 3-D Reference
Inside a function like:
=SUM(Sheet1:Sheet5!B2) -- Gary''s Student - gsnu200798 "FirstVette52" wrote: I need help with aq 3-D reference error (REF#): ='Sheet1:Sheet5'!B2 Thanks for the help -- FirstVette52 |
| 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 | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
Hybrid Mode
