Here you go...
Sub ButtonName_Click()
ActiveCell.Offset(1,0) = Left(ActiveCell,10)
End Sub
--
Chris Farkas
Excel/Access Developer
http://www.eAlchemy.biz
" wrote:
Hi,
For example, I am working on cell G8. I would like to set up a button
that, once clicked, copies and pastes the first 10 characters from D8
and pastes it into H8. The same process would apply if I am on G33,
i.e.copy first 10 characters from D33 and paste into H33, etc, etc.
I can't figure it out.
Can someone help?
Tony