View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] annysjunkmail@tiscali.co.uk is offline
external usenet poster
 
Posts: 48
Default Selecting 10 charcters on one cell and pasting to another cell

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