Copy from the formula toolbar or select the cell, press F2, press shift +
home and ctrl + C and then paste

--


Regards,


Peo Sjoblom

"da" wrote in message
...
HI
I want to copy a cell address which is on a different worksheet (same
file).
How do I do it? I tried using the ADDRESS formula but it does not show
correct result.
The number I want to copy from is on worksheet 1 and copy to worksheet 4.
The cell address in worksheet 1 is Row 4, Column D.
thank you