Hi all, noob here
What I want to do is create a button that I can place into a cell that will insert a row above the button without messing up the left hand merged cells.
so if I was to place the button into cell I3 and I the function of this button is to insert a row above, but the catch is that columns A-H have got rows 2 and 3 merged.
This is what I have below
..A..B..C..D..E..F..G..H.......I
1
----------------------|------|--------
2..............................|------|--------
3..............................|Button|--------
----------------------|-------|-------
I want
..A..B..C..D..E..F..G..H.......I
1
----------------------|------|--------
2..............................|------|--------
3..............................|------|--------
4..............................|Button|--------
----------------------|-------|-------
I have this setup multiple times down the page so I will want multiple buttons, I dont want the user to have to select the cell to insert the row above into if thats possible.so insert the row about the location of the button.
So if I want to add in another key date for a project I can click this button to insert another row where I can fill out the fields to the right.
I have tried a number of ways, using offsets but I am fairly new to VBA and macro creation. I found that when you added rows say for the first button located on the sheet that initially would be at I3 the references for the other buttons usually went out, I have tried to use a variable that is changed each button press to keep the stuff in order but I dont think i did it right.
Any help would be greatly appreciated.
Thanks
picture below
button.JPG
Bookmarks