My Aswer Is This
Well-known Member
- Joined
- Jul 5, 2014
- Messages
- 19,511
- Office Version
- 2021
- Platform
- Windows
How can I always reference Cell(1,1) even if that cell is deleted?
For example I want cell(1,2) to always show what is in cell(1,1) if I delete cell(1,1) I still want cell(1,2) to show what's in cell(1,1). There will always be a cell(1,1) even if you delete the cell another cell takes it place.
I have tried defining cell(1,1) but if I then delete cell (1,1) I get a # Ref in cell(1,2).
This is just a example I may want cell(20,13) to refer to cell(1,1) so I cannot use a offset function.
For example I want cell(1,2) to always show what is in cell(1,1) if I delete cell(1,1) I still want cell(1,2) to show what's in cell(1,1). There will always be a cell(1,1) even if you delete the cell another cell takes it place.
I have tried defining cell(1,1) but if I then delete cell (1,1) I get a # Ref in cell(1,2).
This is just a example I may want cell(20,13) to refer to cell(1,1) so I cannot use a offset function.