View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Forcing to paste on a specific row

Maybe another idea...

Can you figure out where it should be pasted (in code)?

If you can, then maybe you could provide a dedicated worksheet where the user
always pastes in A1.

Then after they paste, you copy the range to the correct spot, and then clean up
that dedicated worksheet for the next time.

If the user doesn't need to make any other changes to the "real" worksheet, you
could even password protect it.

Then your code could unprotect it, do the work, and reprotect it.

Denys wrote:

Good day everyone,

Is it possible to force the user to paste on specific rows? As the
user will copy info from a page of a non Windows application and then
"Special paste Unicode text" on an excel spreadsheet, I'd like to
force him to paste only on specific rows, i.e. 1, 75, 150, 225, 300,
etc....

In other words, if there's something in cell A1, the you must paste on
cell A75, then the third time on cell A150 etc....

Is it possible?

Thanks for your time

Denys


--

Dave Peterson