Copy to Clipboard VBA

[nacskins]

I apologize for any newb mistakes. I am new to learning excel and real new to VBA code. I was wondering if anyone can help me with a code.
I want to have a Axtive X Command button then when you click the button it copies the text contents from another sheet without switching and highlighting that cell (silent?) i have code for copying to clipboard from the same sheet but it only works well when the command button is on the same sheet on top of the cell. If you move the text it will jump and highlight that cell. Again i apologize if its not clear what i am looking for. Here is the code i have that works for copy to clipboard using the command button.

Private Sub CommandButton1_Click()
Range("F48").Select
Selection.Copy

 

[fredlo2008]

Hello,

Change the sheet name with the one you need

Private Sub CommandButton1_Click()    
Sheets("sheet name").Range("F48").Copy
End Sub

 

[nacskins]

Works Perfect Thank you very much!