copy/paste a cell formula without changing it

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

Originally Posted by protonLeah

Copy from the Formula bar instead of the cell.

I would but it's for 150 more cells. There must be a shorter way.

Put $ to make it absolute
Change (A1:UX1) to ($A$1:$UX$1)

Originally Posted by Cutter

Put $ to make it absolute
Change (A1:UX1) to ($A$1:$UX$1)

Worked like a charm, thanks.