View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bart van den Burg Bart van den Burg is offline
external usenet poster
 
Posts: 8
Default prevent pasting into multiple lines

Hi

I have a sheet with a macro on it, which dynamically hides and shows
specific rows.
However, when, say, for example, all lines except 173 and 285 ar hidden, and
the user wishes to copy a row to those rows, and thus selects them both, and
presses ctrl-v, all the lines in between will be pasted to as well... Is
there any way to prevent this with an onCopy event or something like that?

Thx
Bart