LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cut and paste specific data Father John Excel Discussion (Misc queries) 1 April 19th 10 11:33 PM
Copy, Paste in a specific format DB Excel Discussion (Misc queries) 0 May 2nd 07 07:47 PM
Forcing scientific notation to a specific power C.O. Excel Discussion (Misc queries) 1 September 19th 06 11:03 PM
Forcing a specific date format DianeMcP New Users to Excel 10 October 27th 05 05:03 PM
Macro to Paste to specific line, and continue to Paste each time on next row not over tomkarakowski[_2_] Excel Programming 1 May 28th 04 06:50 PM


All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"