Adding a row in Excel on the location of the selected box
up vote
0
down vote
favorite
I'm fairly new to using Macro's and code. For work I'm trying to build an Excel sheet with a macro that inserts a new row on the location of the selected box.
Sofar I have found several codes that make the new row, but all on a set location. I.e. A3. In the sheet there must be an option to add the row at any given location.
I can not find anything on the interwebs sofar.
Does someone have a solution?
excel vba excel-vba rows
edited Nov 22 at 13:06
Pᴇʜ
19.9k42650
asked Nov 22 at 13:03
N. Sinse
31
add a comment |
up vote
0
down vote
favorite
I'm fairly new to using Macro's and code. For work I'm trying to build an Excel sheet with a macro that inserts a new row on the location of the selected box.
Sofar I have found several codes that make the new row, but all on a set location. I.e. A3. In the sheet there must be an option to add the row at any given location.
I can not find anything on the interwebs sofar.
Does someone have a solution?
excel vba excel-vba rows
edited Nov 22 at 13:06
Pᴇʜ
19.9k42650
asked Nov 22 at 13:03
N. Sinse
31
Can you show us what code you have so far?
– rohrl77
Nov 22 at 13:08
Ectualy not much. the awnser given was what I needed. but then I got stuck on the part where I also want to copy the folumas in to the newly added row.
– N. Sinse
Nov 23 at 14:06
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm fairly new to using Macro's and code. For work I'm trying to build an Excel sheet with a macro that inserts a new row on the location of the selected box.
Sofar I have found several codes that make the new row, but all on a set location. I.e. A3. In the sheet there must be an option to add the row at any given location.
I can not find anything on the interwebs sofar.
Does someone have a solution?
excel vba excel-vba rows
edited Nov 22 at 13:06
Pᴇʜ
19.9k42650
asked Nov 22 at 13:03
N. Sinse
31
I'm fairly new to using Macro's and code. For work I'm trying to build an Excel sheet with a macro that inserts a new row on the location of the selected box.
Sofar I have found several codes that make the new row, but all on a set location. I.e. A3. In the sheet there must be an option to add the row at any given location.
I can not find anything on the interwebs sofar.
Does someone have a solution?
excel vba excel-vba rows
excel vba excel-vba rows
edited Nov 22 at 13:06
Pᴇʜ
19.9k42650
asked Nov 22 at 13:03
N. Sinse
31
edited Nov 22 at 13:06
Pᴇʜ
19.9k42650
asked Nov 22 at 13:03
N. Sinse
31
edited Nov 22 at 13:06
Pᴇʜ
19.9k42650
edited Nov 22 at 13:06
Pᴇʜ
19.9k42650
edited Nov 22 at 13:06
Pᴇʜ
19.9k42650
19.9k42650
asked Nov 22 at 13:03
N. Sinse
31
asked Nov 22 at 13:03
N. Sinse
31
asked Nov 22 at 13:03
N. Sinse
31
31
Can you show us what code you have so far?
– rohrl77
Nov 22 at 13:08
Ectualy not much. the awnser given was what I needed. but then I got stuck on the part where I also want to copy the folumas in to the newly added row.
– N. Sinse
Nov 23 at 14:06
add a comment |
Can you show us what code you have so far?
– rohrl77
Nov 22 at 13:08
Ectualy not much. the awnser given was what I needed. but then I got stuck on the part where I also want to copy the folumas in to the newly added row.
– N. Sinse
Nov 23 at 14:06
Can you show us what code you have so far?
– rohrl77
Nov 22 at 13:08
Can you show us what code you have so far?
– rohrl77
Nov 22 at 13:08
Ectualy not much. the awnser given was what I needed. but then I got stuck on the part where I also want to copy the folumas in to the newly added row.
– N. Sinse
Nov 23 at 14:06
Ectualy not much. the awnser given was what I needed. but then I got stuck on the part where I also want to copy the folumas in to the newly added row.
– N. Sinse
Nov 23 at 14:06
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
To insert a row above the selected cell use the Range.Insert method:
Selection.EntireRow.Insert xlShiftDown
answered Nov 22 at 13:08
Pᴇʜ
19.9k42650
thank you for the solution!
– N. Sinse
Nov 22 at 13:45
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
To insert a row above the selected cell use the Range.Insert method:
Selection.EntireRow.Insert xlShiftDown
answered Nov 22 at 13:08
Pᴇʜ
19.9k42650
thank you for the solution!
– N. Sinse
Nov 22 at 13:45
add a comment |
up vote
0
down vote
accepted
To insert a row above the selected cell use the Range.Insert method:
Selection.EntireRow.Insert xlShiftDown
answered Nov 22 at 13:08
Pᴇʜ
19.9k42650
thank you for the solution!
– N. Sinse
Nov 22 at 13:45
add a comment |
up vote
0
down vote
accepted
up vote
0
down vote
accepted
To insert a row above the selected cell use the Range.Insert method:
Selection.EntireRow.Insert xlShiftDown
answered Nov 22 at 13:08
Pᴇʜ
19.9k42650
To insert a row above the selected cell use the Range.Insert method:
Selection.EntireRow.Insert xlShiftDown
answered Nov 22 at 13:08
Pᴇʜ
19.9k42650
answered Nov 22 at 13:08
Pᴇʜ
19.9k42650
answered Nov 22 at 13:08
Pᴇʜ
19.9k42650
answered Nov 22 at 13:08
Pᴇʜ
19.9k42650
19.9k42650
thank you for the solution!
– N. Sinse
Nov 22 at 13:45
add a comment |
thank you for the solution!
– N. Sinse
Nov 22 at 13:45
thank you for the solution!
– N. Sinse
Nov 22 at 13:45
thank you for the solution!
– N. Sinse
Nov 22 at 13:45
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431653%2fadding-a-row-in-excel-on-the-location-of-the-selected-box%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Can you show us what code you have so far?
– rohrl77
Nov 22 at 13:08
Ectualy not much. the awnser given was what I needed. but then I got stuck on the part where I also want to copy the folumas in to the newly added row.
– N. Sinse
Nov 23 at 14:06