I've used to the Macro Recorder and modifyed a bit but my syntax and understanding are off a bit -- I am trying to paste blank/unformated (and without formulas) lines within a protected sheet. My macros are InsertBlank and Inser -- they are basically the same. My issue is how can I get my copied line ( row 90) to copy to a destination of where ever the cursor is pointed -- either on the line # or in column A.
Thanks for any attention and effort, Dan
Last edited by DJBittner; 10-10-2011 at 11:34 AM. Reason: works like a charm!
Hi Dan
The only way I know is to use input prompts whereby the user would be asked to click on a cell in the row to be copied from then be asked to click on a cell in the row to be copied to.
Does this approach interest you?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hey John, yes, your approach does interest me -- my only concerns are that the row is copied/inserted within a specific range: anywhere between rows 9 and 70-something. I could do without prompting if my macro can determine the current position of the mouse/active cell. Also, the method I tried involved copying a non-formatted, non-formula-ed row because I am attempting to add a free-fill comment line. Thoughts?
Hi Dan
Looking at Worksheet TED...you want a totally blank line somewhere in the main body (rows 9 through 70 something) such that TED would look like this after the insert?
yes - I need a blank line, without any formatting, so a supervisor/foreman can insert comments on an above entry. And I need to be able to direct the placement of the blank line.
Hi Dan
This code has been added to the attachedAnd in Module 5
Please Login or Register to view this content.Place your cursor on the row where you wish to insert the row then press the keyboard shortcut (CTRL + I). Let me know of issues.Please Login or Register to view this content.
Thanks again John -- works great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks