View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bb pcv bb pcv is offline
external usenet poster
 
Posts: 1
Default Paste upon click

I would like to write a macro, to be attached to a label, that upon clicking
the label, would put the named range on the clipboard, and then paste the
range at a cell in the worksheet with another click.
current code:
Sub More_time()
Range("More_Time").Select
Selection.Copy
End Sub
would like to paste by clicking