To take the macro from this spreadsheet and use it in another you can go into visual basic editor and copy the contents of the macro into the module on the new spreadsheet.
IE: Alt F11 to open up vb editor, double click module1, find the code starting with sub RowShift() and copy the whole thing. Open up the new spreadsheet, Alt F11, double click module1, paste. When you run the macro window it should show up as an option.
Alternatively, if you want to try it out on the new spreadsheet, as long as you have the test.xls spreadsheet open, the function should be "shared" between spreadsheets.
No, I'm sorry. The only thing that seems to work is wikisend?
Does this form have a button on the sheet? If not, can you add one?
I like, thank you very much. Can you make it only copy formats and formulas, not the actual contents of the cells being copied?
Also, change the words to say "How many lines would you to insert?"
Ok. I really need to do it, otherwise it will create more work. I guess I should've been more specific in my original question.
Thank you so much!
I'm having trouble loading you excel sheet macro into my workbook? I keep getting a "Sub or Function Not Defined" message? Please help.
Did you ever figure out how to do a paste special with a macro?
Okay, I have 4 different sheets I want to use this on.
The biggest sheet needs the values in these columns deleted after the rows are inserted:
I can modify the code later for the other sheets.
Actually, they are:
D,E,H,T,U,V through DM.
I had T & U in the columns to be deleted, but they actually need to be copied and pasted.
I would prefer go by which columns need to have the contents deleted.
I like, but it did not copy my conditional formats right. Do you know a way to copy conditional formats and not affect the formulas?
If not, that is okay.
Manually, this done by highlighting part of the row, then grabbing the corner and dragging down. Not sure how to do that in VBA?
Also, the row number that is entered as the location to insert, it's data is being deleted as well as the new inserted rows? I want to keep the original row's data.
Okay, if want to stop helping, I understand. I think my intentions from the start have stayed in tact, I've just had to see it work to see if it is what I wanted.
I'll throw you a bunus (I was going to anyway). Up to you.
The above code had an error. Where it says Paste, I believe it should say Selection.Paste. Also, when I run it, it gives me a "400" error.