Worksheet Selection change for many cells

This code only works for one cell. I'm trying to make this code work for multiple columns. Example: if I select cell D29 and enter a 0, I would be the contents of cell U3 to be copied and pasted into cell D33 and so on down the columns until I reach the last column which is N. I may only select one column to change or I may select more than one column, but one at a time. I've tried many ways to accomplish this over the last two days and I would like any help I could get. Thanks, Jim

Please Login or Register  to view this content.

Hello Jamesera27,

More examples of what you are trying to do are needed. If you have a workbook with the code and data described in your post, please post it.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

Please Login or Register  to view this content.

Regards, TMS

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.