Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute cell references
Hi Newman,
you should be able to use both relative AND absolute. Do you mean you can't do the absolute: =SUM(Sheet2!$A$1:$A$20) but you can do the relative: =SUM(Sheet2!A1:A20) ? Regards, Sebastien "Newman" wrote: Why can't I put in absolute cell references in a formula when the cell being referenced is on another sheet in the same workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute Cell References | Excel Worksheet Functions | |||
absolute cell references | Excel Discussion (Misc queries) | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Absolute cell references | Excel Programming | |||
Absolute cell references | Excel Programming |