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

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