View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default prevent pasting into multiple lines

Look in HELP for SPECIALCELLS

--
Don Guillett
SalesAid Software

"Bart van den Burg" wrote in message
...
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