Hello,
How can I copy/paste a cell formula without changing it?
For example:
=ADDRESS(2;MATCH(((LEFT(INDIRECT(ADDRESS((ROW()-1);COLUMN();4));(LEN(INDIRECT(ADDRESS((ROW()-1);COLUMN();4)))-1)))+0);(A1:UX1);0);4)
If I click on a cell and copy/paste it to another, the bold part of the above formula will change.
How can I do this without having it changed?
Regards
Bookmarks