PDA

View Full Version : Basic Help: Copy value from one sheet to another



afzalw
05-09-2013, 02:42 PM
Can any one correct whats wrong with this code. I want to copy the last value in last cell of D column Sheet 2 to Sheet 1 cell B1.




Set rDest = Sheets(1).Range("B1")
rDest.Value = Sheets(2).Range("D2").End(xlDown).Value

Paul_Hossler
05-09-2013, 06:54 PM
What happens when you run it?

Paul