Re: Set the value of the current row and column to a cell
So this is a command button on the sheet Enter and you want it to take the value of the cell that is selected and copy that into cell A2. If not please explain further. Target is usually passed to a worksheet event like selection change or change.
Try this code. If the button is on sheet Enter and the cell you want the value from is the active cell then it will give you the value from that cell.