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:
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:
Code:
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