[VBA]
If cmbSelectRest.value = "Olaya" then
Copy the value of "Sheet Olaya" Range b5:n39 to activeworksheet with the same range?
End if
[/VBA]
[VBA]
If cmbSelectRest.value = "Olaya" then
Copy the value of "Sheet Olaya" Range b5:n39 to activeworksheet with the same range?
End if
[/VBA]
[VBA]Sheets("Olaya").Range("B5:N35").Copy Destination:=ActiveSheet.Range("B5:N35")[/VBA]
If you just want values, without formatting or formulas,
Code:ActiveSheet.Range("B5:N35") = Sheets("Olaya").Range("B5:N35")
Good point Mike....I missed that point and just saw "copy"
Never thought about that, Mike. Pretty cool :) Thanks
:thumb That easy ha? Thanks people...