[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]
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
[VBA]Sheets("Olaya").Range("B5:N35").Copy Destination:=ActiveSheet.Range("B5:N35")[/VBA]
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
If you just want values, without formatting or formulas,
ActiveSheet.Range("B5:N35") = Sheets("Olaya").Range("B5:N35")
Good point Mike....I missed that point and just saw "copy"
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Never thought about that, Mike. Pretty cool Thanks
New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
That easy ha? Thanks people...
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.