Code for special copy and paste

[a.sharaf]

HI...
i have cell a3 as a reference to another cell lets say z4 is written in cell a3 i want a code to help me select z4 from cell a3 my code goes as follows:

Range("A3").Select
    Application.CutCopyMode = False
    Selection.Copy
    ' I WANT TO WRITE HERE A CODE TO LET THE COMPUTER SELECT CELL Z4 THROUGH CELL A3 LETS SAY { RANGE("A3").VALUE.SELECT } SO THE COMPUTER WILL SELECT CELL Z4 CAUSE ITS WRITTEN IN CELL A3    
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

 

[jbodell]

You may need to elaborate on your issue/goal.

Is there a reason you aren't using:

Range("A3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks

This would paste the value of Z4 into A3.

 

[a.sharaf]

thanks for the tip but imply what i want is as follows:
I want to select the cell referred to in cell a3. lets say z4 is typed in cell a3 so i want to automatically select cell z4 through cell a3