Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cut and paste specific data | Excel Discussion (Misc queries) | |||
Copy, Paste in a specific format | Excel Discussion (Misc queries) | |||
Forcing scientific notation to a specific power | Excel Discussion (Misc queries) | |||
Forcing a specific date format | New Users to Excel | |||
Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming |