| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell reference OR INDIRECT function
If I use cell references the correct link to the data in cell in lost when
rows are inserted. Therefore I use the INDIRECT(column()&row()) format, Is there another way, because my formula's are incresing dramaticaly -- Shared knowledge kan make you smarter |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell reference OR INDIRECT function
On Jun 6, 10:00 am, Excel ESG
wrote: If I use cell references the correct link to the data in cell in lost when rows are inserted. Therefore I use the INDIRECT(column()&row()) format, Is there another way, because my formula's are incresing dramaticaly -- Shared knowledge kan make you smarter There is no other way to *always* refer to A1 regardless of insertions, deletions or moving of cells except: =INDIRECT("A1") =INDIRECT(ADDRESS(1,1)) Are your formulas increasing in size or population? HTH Kostis Vezerides |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell reference OR INDIRECT function
I was already afraid for that answer,
Although thanks for your responce -- There are only 10 types of people in the world: Those who understand binary and those who don''t. "vezerid" wrote: On Jun 6, 10:00 am, Excel ESG wrote: If I use cell references the correct link to the data in cell in lost when rows are inserted. Therefore I use the INDIRECT(column()&row()) format, Is there another way, because my formula's are incresing dramaticaly -- Shared knowledge kan make you smarter There is no other way to *always* refer to A1 regardless of insertions, deletions or moving of cells except: =INDIRECT("A1") =INDIRECT(ADDRESS(1,1)) Are your formulas increasing in size or population? HTH Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can INDIRECT function reference a cell that contains a formula | Excel Worksheet Functions | |||
| Cell reference within a indirect.. | Excel Worksheet Functions | |||
| indirect function within sumif to reference other sheets | Excel Worksheet Functions | |||
| indirect function to reference cell on different sheet | Excel Worksheet Functions | |||
| Use INDIRECT function to reference a value in closed file | Excel Worksheet Functions | |||
Linear Mode
