this is the macro i have created to copy the range e2:e53 and paste those values in j2:j53. when i attempt to run i get an error
Please Login or Register to view this content.
"compile error: expected end sub"
what does this mean. i am very new to VBA and this is the first one that i have attempted so i apologize for how rookie of a mistake this is. thank you for any help given!
You are simply missing theline at the very end. With that said,Please Login or Register to view this content.
will accomplish the same thing.Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
oh i see...silly mistake. thank you very much. i really like the improvement you made on what i had put together - very logical. i hope most of the things i encounter in the future are as easy as this
You are getting the error because the "End Sub" is missing at the end of your code.
Also, you can change your code to thisPlease Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks