Thread
:
prevent pasting into multiple lines
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]