Excel: copy active cell to same cell in sheet 2.

I want to copy active cell if sheet 1 to same cell in sheet 2 by using vba button. Active cell is not the same each time. I use: Range (sheet1!a2).value = range(sheet2!a2) but this does 9nly for the cell a2 and not the active cell each time.

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of April 19, 2015.

For more resources for Microsoft Excel