PDA

View Full Version : Solved: How to Copy Values from another worksheet to Activeworksheet



jammer6_9
11-17-2007, 07:56 AM
If cmbSelectRest.value = "Olaya" then

Copy the value of "Sheet Olaya" Range b5:n39 to activeworksheet with the same range?

End if

lucas
11-17-2007, 08:07 AM
Sheets("Olaya").Range("B5:N35").Copy Destination:=ActiveSheet.Range("B5:N35")

mikerickson
11-17-2007, 09:30 AM
If you just want values, without formatting or formulas,

ActiveSheet.Range("B5:N35") = Sheets("Olaya").Range("B5:N35")

lucas
11-17-2007, 09:41 AM
Good point Mike....I missed that point and just saw "copy"

malik641
11-17-2007, 06:22 PM
Never thought about that, Mike. Pretty cool :) Thanks

jammer6_9
11-18-2007, 01:08 AM
:thumb That easy ha? Thanks people...