button macro help

  • Thread starter Thread starter greg7468
  • Start date Start date
G

greg7468

Hello all,
I have a command button by where I want to say transfer the values i
A1 to the active cell in the sheet. Could someone please help me wit
the macro.
Thank you in advance
 
Greg,

Try something like

ActiveCell.Value = Range("A1").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
greg

To transfer the value use

Sub Move_Value()
Range("A1").Cut Destination:=ActiveCell
End Sub

To copy the value use

Sub Copy_Value()
ActiveCell.Value = Range("A1").Value
End Sub

Gord Dibben Excel MVP
 
thank you both for your replies, you really do save people many hour
trying in vain to find the correct solution
 
Back
Top