| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want cell A1 to equal $A$2 even after inserting line at A2
Whenever I make cell 'A1' = '$A$2 and insert a line at 'A2', the value 'A1'
gives me is that of 'A3'. I would like 'A1' to equal whatever number inserted into 'A2'. I am using office excell 2003. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want cell A1 to equal $A$2 even after inserting line at A2
Try this:
A1: =OFFSET(A1,1,0) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "adamb2000" wrote: Whenever I make cell 'A1' = '$A$2 and insert a line at 'A2', the value 'A1' gives me is that of 'A3'. I would like 'A1' to equal whatever number inserted into 'A2'. I am using office excell 2003. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want cell A1 to equal $A$2 even after inserting line at A2
Thanks Ron,
That's exactly what I wanted. Cheers Adam "Ron Coderre" wrote: Try this: A1: =OFFSET(A1,1,0) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "adamb2000" wrote: Whenever I make cell 'A1' = '$A$2 and insert a line at 'A2', the value 'A1' gives me is that of 'A3'. I would like 'A1' to equal whatever number inserted into 'A2'. I am using office excell 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line selection from a cell script through a VBA macro | Setting up and Configuration of Excel | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
