No problem. Now you know :-)

I always try to click the cell to get the address rather than typing it out
unless it is like =A1.
--
If you find this post helpful pl. choose "Yes"...


"da" wrote:










Thanks. It worked. It was so easy, I should have known that, duh...












"Sheeloo" wrote:

Enter in the desired cell in Sheet4
(I am assuming sheet name is Sheet1 for worksheet1)

=Sheet1!D4

OR you can also enter = in any cell in Sheet4
Then click on Sheet1
Click on D4
Press Enter and you are done

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.
--
If you find this post helpful pl. choose "Yes"...


"da" wrote:

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.

thank you