frank_m
10-05-2010, 01:32 PM
I am hoping to find a vba code method to get the value from the cell that is located in another sheet, but it needs to be the cell that was last activated in that sheet.
Thanks in advance.
Of course the code below is incorrect, but it shows what I am after.
Sheets("DESTINATION SHEET").Range("A2").Value = Sheets("SOURCE SHEET").ActiveCell.Value
Thanks in advance.
Of course the code below is incorrect, but it shows what I am after.
Sheets("DESTINATION SHEET").Range("A2").Value = Sheets("SOURCE SHEET").ActiveCell.Value