View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
howard howard is offline
external usenet poster
 
Posts: 68
Default Change paste to paste special

I tried this before, but I can't get things to work the way I want. PROBABLY
because I didn't explain things correctly.

I want to declare a range of cells (K18:K37), on sheet 1, the active spread
sheet, so that when a user clicks on one of these cells, and clicks paste, it
will actually paste special as a value. (The same as if the user clicked
"paste special" and then "value".

Thanks for any help you can give.
--
Howard