macro to copy the row that my cursor is on, then insert that copied row above that row
macro to copy the row that my cursor is on, then insert that copied row above that row
Add this code to the worksheet code
![]()
Please Login or Register to view this content.
Click on the star if you think I helped you
Maybe:
![]()
Please Login or Register to view this content.
Thanks for your help. I only know how to create macros in Excel 2011 using the Tool/Macros/Record Macro.
I tried clicking on Visual Basic Editor, typing what you wrote, but that didn't work. I guess I need to learn how to write macros in VBE.
Alt-F11 will bring up the VBE. On the left side select your Project (name of workbook.xlsx). Go to your menu Insert Module. Copy code from this website and paste in the Module.
Thread posted in CS subforum, hence closed.
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)
Bookmarks